Re: plpgsql grief

> Thus your only way to get stuff back from EXECUTE is to save
> the results you want to a temporary table (using CREATE
> TABLE AS ...), and read them back using a query. Not
> high-performance, but it gets the job done.
>

I believe this statement is incorrect, quoting Michael Ansley
<Michael(dot)Ansley(at)intec-telecom-systems(dot)com> from a previous e-mail:

<QUOTE>
create function testfunc (text) returns int4 as '
declare
sql varchar;
begin
sql=''SELECT id AS res2 FROM ''||$1 ;
execute sql ;
return res2;
end;
' language 'plpgsql' ;

Please note the AS syntax rather than INTO. This was a misconception on
my part, which has obviously lasted longer than I'd hoped ;-)
</QUOTE>

I believe this was the consensus reached on the hacker's list.....

Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio