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