Hi Ray, thanks for reply. Your solution needs to be modified with alias to get executed properly:
CREATE OR REPLACE FUNCTION A3() RETURNS VOID AS $BODY$ begin select * from A1() as dummy ( x double precision ); return; end; $BODY$ LANGUAGE 'plpgsql'; but when used: select * from A3() it generates error "query has no destination for result data". That was the reason to use PERFORM in the first place.. "Raymond O'Donnell" <r...@iol.ie> napisał(a): > On 18/02/2010 12:05, wilcza...@op.pl wrote: > > > > > CREATE OR REPLACE FUNCTION A3() RETURNS VOID AS $BODY$ > > begin > > perform A1(); > > end; > > $BODY$ LANGUAGE 'plpgsql'; > > You need to do: > > select * from A1(); > > Ray. > > -- > Raymond O'Donnell :: Galway :: Ireland > r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
