Can a function return tuples

From: Werachart Jantarataeme <it072560(at)it(dot)kmutt(dot)ac(dot)th>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Can a function return tuples
Date: 1999-05-10 08:50:25
Message-ID: Pine.GSO.3.93.990510154646.19591A-100000@pegasus1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


I am start programming on Postgres and looking for how to return a set of
tuples for a function;

As see on man pages of "create_function", there is an example of function
hobbies which return "set of HOBBIES".

example:
create function hobbies (EMP) returns set of HOBBIES
as 'select (HOBBIES.all) from HOBBIES
where $1.name = HOBBIES.person'
language 'sql'
result:
ERROR: parser: parse error at or near "set".

An on last line of the man pages said "C functions cannot return a set of
values." Is there this fix on lastest version 6.5beta1?

WChart.

Browse pgsql-hackers by date

  From Date Subject
Next Message Werachart Jantarataeme 1999-05-10 08:51:16 How can I use UNION in VIEW/RULE?
Previous Message Tatsuo Ishii 1999-05-10 08:26:54 Re: [HACKERS] Beta2?