Re: Help trying to write my first plpgsql function...

On 9/15/05, Bjørn T Johansen <btj(at)havleik(dot)no> wrote:
>
> Yes, I did and I found an answer... :)

you did what? read the docs?

But I am trying to use this function in a report designer and the result
> from the
> select is in the way of the real data from the fetch... Is there a way
> around this?
>

and?
as i said: define the function as setof something.
for example (i'm wrinting without testnig, so there might be small mistakes)

create type srf_type_1 ( field1 int4, field2 text);

create or replace function test () returns setof srf_type_1 as
$BODY$
declare
temprec srf_type_1%ROWTYPE;
begin
for temprec in select id as field1, username as field2 from users where
is_active = true loop
return next temprec;
end loop;
return;
end;
$BODY$
language 'plpgsql';

should work as select * from test();

hubert