Returning more than one value from a stored procedure

From: Atif Jung <atifjung(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Returning more than one value from a stored procedure
Date: 2010-07-08 09:51:28
Message-ID: AANLkTikgwIG5FT2CyBLbqVMUekLmwWn1isVHf_7nqtSL@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I'm having difficulty working out the correct syntax to return more than one
value from a stored procedure. I wish to return an INTGER and a string

CREATE or REPLACE FUNCTION testproc(val1 (CHAR9), val2 CHAR(4)) RETURNS
INTEGER, CHAR(640) AS $$

The above is incorrect but what is the correct syntax?

Thanks

Atif

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message A. Kretschmer 2010-07-08 10:14:04 Re: Returning more than one value from a stored procedure
Previous Message Jean-Yves F. Barbier 2010-07-07 21:43:26 Re: how to extract and use a string like a constraint?