470,614 Members | 1,458 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

Question on stored functions

Hi,

I could only find support for defining functions in pl/pgsql.
With a function I can have only one return value. What if I need
to have multiple OUT parameters (i.e multiple return values) ?
Is there any support for something that is similar to an Oracle
stored procedure ?

I understand that I can return a REFCURSOR from a postgres function,
but my question is for a case, say, where I need to return 2 string
variables/values based on some logic in addition to a REFCURSOR.
How do I do that in pl/pgsql ?

Thanks,

Gunjeet
Jul 19 '05 #1
0 1499

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by lixiaoyao | last post: by
6 posts views Thread by Arthur J. O'Dwyer | last post: by
5 posts views Thread by Ale K. | last post: by
2 posts views Thread by Eitan | last post: by
13 posts views Thread by poison.summer | last post: by
7 posts views Thread by Csaba Gabor | last post: by
9 posts views Thread by Mike Hofer | last post: by
1 post views Thread by pitjpz | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.