On 19/02/2010 09:59, wilczarz1@xxxxx wrote: > 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.. Yes, you're absolutely right - the returned data needs a destination. I should have written: perform * from A1(); That ought to work too. 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
