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

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