Re: PERFORM not working properly, please help..

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
usePERFORM in the first place.. 

"Raymond O'Donnell" <rod@iol.ie> napisał(a):
 > On 18/02/2010 12:05, wilczarz1@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
 > rod@iol.ie