Thread: Newbie help needed on Functions

I'm not an expert, but I think that a function cannot directly return a rows set. You have to use a cursor

http://www.postgresql.org/idocs/index.php?plpgsql-cursors.html

 I use the following (postgresql 7.2) to  get multiple rows in a table, but the table must exist before you run the function.

Don't forget double quotes (1+1) for the variable in the query

You have to install pl/pgsql language before ...

CREATE FUNCTION test(varchar) RETURNS varchar AS '

declare str alias for $1;

declare str_ok varchar(2);

begin

str_ok = 'OK'

drop table tmp_result;

create table tmp_result as select a.*  from your_table a where a.state=''str'';

return str_ok;

end;

' LANGUAGE 'pl/pgsql';