Question on stored functions

From: Gunjeet Singh <Gunjeet(dot)Singh(at)eng(dot)sun(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: gunjeet(dot)singh(at)sun(dot)com
Subject: Question on stored functions
Date: 2004-03-03 18:51:45
Message-ID: 200403031851.i23IpjR5444302@jurassic.eng.sun.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2004-03-03 18:52:26 Re: How index are running and how to optimise ?
Previous Message scott.marlowe 2004-03-03 18:43:16 Re: Moving from MySQL to PGSQL....some questions (multilevel