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
hello"
how to Restoring the sql dump pls spacify the command
(path).
=====
Take careMohd.Ghalib Akhtar(office)91-11-6152172,Ext-217
Fax : 91-11-6146217, 6149446
---------------------------------
---------------------------------
__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com
Import Notes
Reply to msg id not found: 001201c2d43a$b9e85d00$800a0a0a@xxx
On Friday 14 Feb 2003 5:09 pm, you wrote:
hello"
how to Restoring the sql dump pls spacify the command
(path).
psql "other options" < sqldumpfile
Shridhar
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.