"Karl O. Pinc" <[EMAIL PROTECTED]> writes:
> ... It just seemed a little wierd
> not to have the %ROWTYPE because AFIK you need it when declaring
> in plpgsql's DECLARE
No, you don't, as 36.4.3 says perfectly clearly. %ROWTYPE is an
Oracle-ism that we support inside plpgsql, but not elsewhere.
On 12/03/2005 11:31:34 PM, Tom Lane wrote:
"Karl O. Pinc" <[EMAIL PROTECTED]> writes:
> Speaking of documentation, it's none too clear that
> %ROWTYPE does not seem to work when declaring plpgsql
> functions.
There is noplace that claims that it does. Perhaps you
are looking for %TYPE?
Nope.
"Karl O. Pinc" <[EMAIL PROTECTED]> writes:
> Speaking of documentation, it's none too clear that
> %ROWTYPE does not seem to work when declaring plpgsql
> functions.
There is noplace that claims that it does. Perhaps you
are looking for %TYPE?
regards, tom lane
-