Re: problem with pl/pgsql
От | Georg Steffers |
---|---|
Тема | Re: problem with pl/pgsql |
Дата | |
Msg-id | 1050588438.1062.7.camel@georg обсуждение исходный текст |
Ответ на | problem with pl/pgsql (Ben <bench@silentmedia.com>) |
Ответы |
Re: problem with pl/pgsql
|
Список | pgsql-general |
Hi, i think its really you whos confused *g* Am Don, 2003-04-17 um 07.40 schrieb Ben: <snip> > The stored proc is: > CREATE or REPLACE FUNCTION Fetch_ArtistSet_By_Artists(integer[]) RETURNS setof integer AS > 'DECLARE > artists alias for $1; > index integer := 1; > total integer := 0; > r record; > q text := ''select setID from (select setID,count(*) as c from artistSet where''; <snip> ok, the proc returns a setof integer. <snip> > > for r in execute q > LOOP > RETURN next r; > END LOOP; > RETURN; > END; <snip> but this returns a record....so what you need here is return next r.setID; Hope this helps you! Greetings Georg Steffers
В списке pgsql-general по дате отправления: