From: | Werachart Jantarataeme <it072560(at)it(dot)kmutt(dot)ac(dot)th> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Function return tuples |
Date: | 1999-05-08 16:24:22 |
Message-ID: | Pine.GSO.3.93.990508084157.15494A-100000@pegasus2 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 | Michael J Davis | 1999-05-08 18:47:28 | RE: [GENERAL] Version of a Postgres installation |
Previous Message | Brett W. McCoy | 1999-05-08 16:14:30 | Re: [GENERAL] postmaster(server) and psql(client) question. |