On 19/02/2010 09:59, [email protected] 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 [email protected] -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
