Postgres Pro
Downloads
Home   >   mailing lists

Thread: set returning functions in v7.3

set returning functions in v7.3

From
Együd Csaba
Date:
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


> 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
>
>

Re: set returning functions in v7.3

From
Tom Lane
Date:
=?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

Re: set returning functions in v7.3 - SORRY

From
Egyud Csaba
Date:
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.

how to restore SQL Dump

From
Mohd Ghalib Akhtar
Date:
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

Re: how to restore SQL Dump

From
"Shridhar Daithankar"
Date:
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