Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

GnatColl

1 view
Skip to first unread message

Cainite 256

unread,
Jul 2, 2009, 8:00:27 AM7/2/09
to
Hello.

I have fast question. I'am using GnatColl to connect witch
PostgreSQL.
Is there any way to call stored function insted of simple query?

Thanks.

Dirk Heinrichs

unread,
Jul 2, 2009, 1:16:19 PM7/2/09
to
Cainite 256 wrote:

> Is there any way to call stored function insted of simple query?

select * from function(arg1, arg2,...);

HTH...

Dirk

Emmanuel Briot

unread,
Jul 2, 2009, 3:20:22 PM7/2/09
to

Not so far, although that should not be too difficult to add. We do
not use stored function ourselves because we have found them harder to
maintain, and we do not need the minor efficiency boost they provide
compared to prepared statements. I guess you could just create a new
instance of SQL_Table where the name is "function (arg1, arg2)". That
would not provide type checking on the Ada side, but at least you
could write the query I think

regards
Emmanuel

0 new messages