Re: problem with pl/pgsql

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