> 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# -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
