set returning functions in v7.3

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:13:33
Message-ID: 000501c2d38b$cb078de0$200a0a0a@notebook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Együd Csaba 2003-02-13 18:24:54 set returning functions in v7.3
Previous Message Greg Stark 2003-02-13 17:39:09 index scan with index cond on first column doesn't recognize sort order of second column