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