By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,985 Members | 1,712 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,985 IT Pros & Developers. It's quick & easy.

Using the result of a function that RETURNS SETOF

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

Expand|Select|Wrap|Line Numbers
  1. create or replace function members(int,char)
  2. returns setof int as...
To list the content of group 2 I execute :

Expand|Select|Wrap|Line Numbers
  1. 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
  1. select idgroup,members(idgroup,'*') from groups;
Someone has a clue ?

Sep 19 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.