From: | "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com> |
---|---|
To: | Patrik Kudo <kudo(at)partitur(dot)se>, pgsql-sql(at)postgreSQL(dot)org |
Subject: | RE: [SQL] Function returning multiple rows? |
Date: | 1999-02-05 17:26:25 |
Message-ID: | F10BB1FAF801D111829B0060971D839F64A6AB@cpsmail |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Not currently.
> -----Original Message-----
> From: Patrik Kudo [mailto:kudo(at)partitur(dot)se]
> Sent: Friday, February 05, 1999 9:54 AM
> To: pgsql-sql(at)postgreSQL(dot)org
> Subject: [SQL] Function returning multiple rows?
>
>
> Hello,
>
> I've been trying to create a function which returns multiple
> rows, but I
> can't get it working. I'm I doing something wrong, or is it not
> possible? This is my setup:
>
> create table groups (userid int4, grp int4);
>
> CREATE FUNCTION usersingroup(int4) RETURNS int4 AS 'SELECT userid FROM
> groups WHERE grp = $1;' LANGUAGE 'sql';
>
>
> When doing a
>
> SELECT usersingroup(100);
>
> I only get the first row. Is there any way to get all the rows?
>
> Regards,
> Patrik Kudo
> kudo(at)partitur(dot)se
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Perdue, The Des Moines City.net | 1999-02-05 22:33:05 | Re: Performance Question |
Previous Message | Juris | 1999-02-05 16:24:14 | Re: [SQL] performance problems of a complex query with 2 subselects |