question about PL/pgSQL function

Поиск
Список
Период
Сортировка
Искать
От
datactrl
Тема
question about PL/pgSQL function
Дата
в 07:25:51
Msg-id
000901c0e9c4$4bd843a0$2400a8c0@hnjack
Список
Дерево обсуждения
question about PL/pgSQL function "datactrl" <quals@bigfoot.com>
Re: question about PL/pgSQL function "Josh Berkus" <josh@agliodbs.com>
Re: question about PL/pgSQL function Jan Wieck <JanWieck@Yahoo.com>
With postgres 7.1
1. Function like example found on 24.4 Example in Programmer Guide   CREATE FUNCTION xxx (EMP, integer) RETURNS boolean AS'......   (which EMP is a table )   How do I pass a record to this function in PL/PGSQL? I try this
....   select into rec1 * from EMP where empNo =''xxxx'';   i1 :=  xxx(rec1,5);
....   But it won't work!
2. Is that possible to return a record from a function? And how do I get the
returned record in PL/pgSql

JACK


В списке pgsql-sql по дате отправления
От: Richard Huxton
Дата:
От: Brian Powell
Дата:
Сообщение: 7.1.1 Lock Problems on Views
FAQ