Re: PERFORM not working properly, please help..

On 19/02/2010 09:59, wilczarz1@op.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
touse 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@iol.ie