-
Function Return Multiple Rows
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|