Re: plpgsql returning resultset

Raymond O'Donnell wrote:

> Can you show us more of your code?

I figured out how to make it work when using "for" instead of "with".

Here is the code and the error message. I couldnt find anything in the
documentation about "with" but I did find something about "for" which I
managed to make work. In any case here is the code for the "with" code:

create or replace function get_profile() returns setof tableA as
$$
declare
val_list tableA%rowtype;
begin

with val_list in
select * from tableA
do
loop
return next val_list;
end loop;

return;
end;
$$ language 'plpgsql';

the error message is:

psql:functions.sql:116: ERROR: syntax error at or near "with $1"
LINE 1: with $1 in select * from attribute_values_part_seq_1_ff_5 ...
^
QUERY: with $1 in select * from attribute_values_part_seq_1_ff_5 do
loop return next $1
CONTEXT: SQL statement in PL/PgSQL function "get_profile" near line 10