Function returns mutliple rows - HELP

On Mon, 27 Jan 2003, juleni wrote:

How can I make function returning multiple tuples?

For example:
============
I have a table COMPANY: id_company | company_name | country
-------------------------------------
1 | Company 1 | Germany
2 | Company 2 | Germany
3 | Company 3 | Slovakia
4 | Company 4 | Slovakia
5 | Company 5 | Slovakia
6 | Company 6 | Italy

I need a function returning all 'company IDs' and 'company names'
from 'Slovakia'.
The parameter to the function is 'country'.

Can anybody give me a simple example how to do it using pl/pgsql by
function returning more tuples?

The set returning functions document on techdocs might help:
http://techdocs.postgresql.org/guides/SetReturningFunctions

For something that simple, I'd probably say that you could get away with a
simple sql function, though, probably something like:
create function getcompaniesbycountry(text) returns company as
'select * from company where country = $1;' language 'sql';