set returning functions in v7.3
От | Együd Csaba |
---|---|
Тема | set returning functions in v7.3 |
Дата | |
Msg-id | 000e01c2d38d$72237110$200a0a0a@notebook обсуждение исходный текст |
Ответы |
Re: set returning functions in v7.3
|
Список | 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@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 > >
В списке pgsql-general по дате отправления: