Using the result of a function that RETURNS SETOF

thefreecat thefreecat is offline

Newbie

Join Date: Sep 2007

Posts: 1

#1: Sep 19 '07

I wrote a function to list the content of a group :

Expand|Select|Wrap|Line Numbers

 create or replace function members(int,char)

returns setof int as...

To list the content of group 2 I execute :

Expand|Select|Wrap|Line Numbers

select * from members(2,'*') memberid;

Now I want to list all the members of each group but I can't figure out the correct syntax (despite several semantically heretic tries).

Something like :

Expand|Select|Wrap|Line Numbers

select idgroup,members(idgroup,'*') from groups;

Someone has a clue ?

TIA,

« previous question | next question »

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,510 network members.

Using the result of a function that RETURNS SETOF

Similar PostgreSQL Database bytes

/bytes/development

/bytes/it

/bytes/about