Home > mailing lists

Returning more than one value from a stored procedure - Mailing list pgsql-novice

From	Atif Jung
Subject	Returning more than one value from a stored procedure
Date	July 8, 2010 09:51:58
Msg-id	AANLkTikgwIG5FT2CyBLbqVMUekLmwWn1isVHf_7nqtSL@mail.gmail.com Whole thread Raw
Responses	Re: Returning more than one value from a stored procedure Re: Returning more than one value from a stored procedure
List	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

From: "Jean-Yves F. Barbier"
Date: 07 July 2010, 21:43:40
Subject: Re: how to extract and use a string like a constraint?

From: "A. Kretschmer"
Date: 08 July 2010, 10:14:15
Subject: Re: Returning more than one value from a stored procedure