Returning multiple rows in functions - Mailing list pgsql-sql

From Kief Morris
Subject Returning multiple rows in functions
Date
Msg-id 30C64922AF42D311A96D00A0C91D0B107EB54D@mailpost.syzygy.net
Whole thread Raw
Responses Re: [SQL] Returning multiple rows in functions
List pgsql-sql
I'm missing something in the docs - how can I write a function
that returns multiple rows? I want to do the equivalent of:
   select name from user_category where id = 21;

I create the following function:
   create function getid (int4) returns text as 'select name from mytable
where id = $1;' language 'sql';

... but it only returns the first matching row. Is there
a way to return all the matching rows?

Thanks,
Kief



pgsql-sql by date:

Previous
From: Justin Long
Date:
Subject: Selecting random element?
Next
From: Peter Eisentraut
Date:
Subject: Re: [SQL] Returning multiple rows in functions