Returning more than one value from a stored procedure

Поиск
Список
Период
Сортировка
От Atif Jung
Тема Returning more than one value from a stored procedure
Дата
Msg-id AANLkTikgwIG5FT2CyBLbqVMUekLmwWn1isVHf_7nqtSL@mail.gmail.com
обсуждение исходный текст
Ответы Re: Returning more than one value from a stored procedure
Re: Returning more than one value from a stored procedure
Список 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


В списке pgsql-novice по дате отправления: