Function returns mutliple rows - HELP

From: juleni <juleni(at)seznam(dot)cz>
To: Postgres-Mailing-List <pgsql-general(at)postgresql(dot)org>
Subject: Function returns mutliple rows - HELP
Date: 2003-01-27 16:46:42
Message-ID: 13513085250.20030127174642@seznam.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Thanks in advance,
julian

mailto:juleni(at)seznam(dot)cz

Responses

Browse pgsql-general by date

  From Date Subject
Next Message will trillich 2003-01-27 16:50:35 Re: too many users for postgresql? :)
Previous Message Chris Gamache 2003-01-27 16:20:21 7.3 LOCK TABLE problem