| 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: | Whole Thread | Raw Message | 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.
| 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? |