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