set returning functions in v7.3 - Mailing list pgsql-general

From Együd Csaba
Subject set returning functions in v7.3
Date
Msg-id 000501c2d38b$cb078de0$200a0a0a@notebook
Whole thread Raw
Responses Re: set returning functions in v7.3  (Brandon Craig Rhodes <brandon@oit.gatech.edu>)
List 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



pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: index scan with index cond on first column doesn't recognize sort order of second column
Next
From: Brandon Craig Rhodes
Date:
Subject: Re: set returning functions in v7.3