Thread: function returning multiple rows?

function returning multiple rows?

From
Patrik Kudo
Date:
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