hi,

can i have a postgreSQl pl/sql function that can return multiple rows

may be the syntax will be like
create or replace function multiple() returns ...

begin
select candidateid from tbl_candidateinfo;

..code to return the result of above statement to calling
program..

end;

and functions will be called as

select candidateid from .. where candidateid in( select multiple());

thanks in advance