Re: [SQL] Returning multiple rows in functions - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: [SQL] Returning multiple rows in functions
Date
Msg-id Pine.LNX.4.21.0003061723580.362-100000@localhost.localdomain
Whole thread Raw
In response to Returning multiple rows in functions  (Kief Morris <k.morris@bitbull.com>)
List pgsql-sql
Kief Morris writes:

> 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?

No. Perhaps making a view would fit your application.

-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden



pgsql-sql by date:

Previous
From: Kief Morris
Date:
Subject: Returning multiple rows in functions
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: [SQL] index file's growing big