RE: plpgsql grief

<p><font size="2">I thought that the discussion on this topic resolved that the AS syntax would work as I described,
andthe INTO syntax would be removed because of ambiguity, to be redeveloped at a later date?</font><p><font
size="2">-----OriginalMessage-----</font><br /><font size="2">From: Tom Lane [<a
href="mailto:tgl@sss.pgh.pa.us">mailto:tgl@sss.pgh.pa.us</a>]</font><br/><font size="2">Sent: 12 February 2001
16:46</font><br/><font size="2">To: Michael Ansley</font><br /><font size="2">Cc: 'rob';
pgsql-sql@postgresql.org</font><br/><font size="2">Subject: Re: [SQL] plpgsql grief </font><br /><p><font
size="2">MichaelAnsley <Michael.Ansley@intec-telecom-systems.com> writes:</font><br /><font size="2">> create
functiontestfunc (text) returns int4 as '</font><br /><font size="2">> declare</font><br /><font size="2">>   sql
varchar;</font><br/><font size="2">> begin</font><br /><font size="2">>   sql=''SELECT id AS res2 FROM ''||$1
;</font><br/><font size="2">>   execute sql ;</font><br /><font size="2">>   return res2;</font><br /><font
size="2">>end;</font><br /><font size="2">> ' language 'plpgsql' ;</font><p><font size="2">> Please note the
ASsyntax rather than INTO.</font><p><font size="2">That won't work :-(</font><p>                        <font
size="2">regards,tom lane</font><code><font size="3"><br /><br />
**********************************************************************<br/> This email and any files transmitted with
itare confidential and<br /> intended solely for the use of the individual or entity to whom they<br /> are addressed.
Ifyou have received this email in error please notify<br /> Nick West - Global Infrastructure Manager.<br /><br /> This
footnotealso confirms that this email message has been swept by<br /> MIMEsweeper for the presence of computer
viruses.<br/><br /> www.mimesweeper.com<br /> **********************************************************************<br
/></font></code>