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