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" <rod@xxxxxx> napisał(a): > On 18/02/2010 12:05, wilczarz1@xxxxx 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 > rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
