RE: [SQL] Function returning multiple rows?
От
Jackson, DeJuan
Тема
RE: [SQL] Function returning multiple rows?
Дата
Msg-id
F10BB1FAF801D111829B0060971D839F64A6AB@cpsmail
Список
Дерево обсуждения
RE: [SQL] Function returning multiple rows? "Jackson, DeJuan" <djackson@cpsgroup.com>
Re: [SQL] Function returning multiple rows? jwieck@debis.com (Jan Wieck)
Not currently. > -----Original Message----- > From: Patrik Kudo [mailto:kudo@partitur.se] > Sent: Friday, February 05, 1999 9:54 AM > To: pgsql-sql@postgreSQL.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@partitur.se >
В списке pgsql-sql по дате отправления
От: Juris
Дата: