> Michal Szymanski <dy...@poczta.onet.pl> writes:
> > CREATE OR REPLACE FUNCTION buggy_procedure() RETURNS TABLE (id INT8,
> > test VARCHAR)
> > AS $$
> > BEGIN
> > -- @todo hide password
> > RETURN QUERY
> > SELECT id ,test
> > FROM bug_table
> > ;
> > END;
> > $$
> > LANGUAGE plpgsql STRICT SECURITY DEFINER;
>
> Don't use column names in your functions that are the same as variable
> or parameter names of the function. This is working basically as if
Thank you, now it works. Using RETURNS TABLE will resolve my other
problem related to the bug/functionality of Postgres -
http://groups.google.pl/group/pgsql.bugs/browse_thread/thread/0647bde500c1b782?hl=pl#