set returning functions in v7.3
Sorry I forgot the error messege. The back end says:
db=# select * from getgroups();
ERROR: parser: parse error at or near "("
But:
db=# select getgroups();
getgroups
-----------
136521504
(1 row)
What is this? Is it an OID?
----- Original Message -----
From: "Együd Csaba" <csegyud@freemail.hu>
To: "pgsql-general" <pgsql-general@postgresql.org>
Sent: Thursday, February 13, 2003 7:13 PM
Subject: set returning functions in v7.3
Show quoted text
Hello,
I have a problem with "set returning functions".
I have a table t_groups. I would like to get the rows of it. I try to call
this function:create or replace function getgroups() returns setof t_groups as '
select * from t_groups;
' language 'sql';in the this way:
select * from getgroups();
It should have returned with all the rows from t_groups. It did not. Where
is the problem?
If ther would be anybody who can help me I wuld be greatful.Thank you very much.
Best regards, Csaba Egyud
=?iso-8859-1?Q?Egy=FCd_Csaba?= <csegyud@freemail.hu> writes:
Sorry I forgot the error messege. The back end says:
db=# select * from getgroups();
ERROR: parser: parse error at or near "("
Try it in 7.3. You seem to be using something older.
regards, tom lane
Tom, others,
I beg your pardon! I was wrong. I accidentally renamed my .gz file from
7.2.3. to 7.3.2. during an mv. I do feel ashamed of it. Could you forgive me
this? :)
Thank you for your help.
Now everything is OK.
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Együd Csaba" <csegyud@freemail.hu>
Cc: "pgsql-general" <pgsql-general@postgresql.org>
Sent: Thursday, February 13, 2003 4:01 PM
Subject: Re: [GENERAL] set returning functions in v7.3
=?iso-8859-1?Q?Egy=FCd_Csaba?= <csegyud@freemail.hu> writes:
Sorry I forgot the error messege. The back end says:
db=# select * from getgroups();
ERROR: parser: parse error at or near "("Try it in 7.3. You seem to be using something older.
regards, tom lane
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.435 / Virus Database: 244 - Release Date: 2002.12.30.