From: | Együd Csaba <csegyud(at)freemail(dot)hu> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | set returning functions in v7.3 |
Date: | 2003-02-13 18:24:54 |
Message-ID: | 000e01c2d38d$72237110$200a0a0a@notebook |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)freemail(dot)hu>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Brandon Craig Rhodes | 2003-02-13 18:25:15 | Re: set returning functions in v7.3 |
Previous Message | Együd Csaba | 2003-02-13 18:13:33 | set returning functions in v7.3 |