Re: problem with pl/pgsql
От | Ben |
---|---|
Тема | Re: problem with pl/pgsql |
Дата | |
Msg-id | 1050593897.10186.2270.camel@purple обсуждение исходный текст |
Ответ на | Re: problem with pl/pgsql (Georg Steffers <georg@steffers.org>) |
Список | pgsql-general |
Worked like a charm. Thanks! On Thu, 2003-04-17 at 07:07, Georg Steffers wrote: > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
В списке pgsql-general по дате отправления: