Can a function return tuples - Mailing list pgsql-hackers

From Werachart Jantarataeme
Subject Can a function return tuples
Date
Msg-id Pine.GSO.3.93.990510154646.19591A-100000@pegasus1
Whole thread Raw
List 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.




pgsql-hackers by date:

Previous
From: "M.J. Blom"
Date:
Subject: Re: Frage!
Next
From: Werachart Jantarataeme
Date:
Subject: How can I use UNION in VIEW/RULE?