Re: PERFORM not working properly, please help..

On 19/02/2010 09:59, wilczarz1(at)op(dot)pl 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(at)iol(dot)ie