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