Re: [GENERAL] Use of %ROWTYPE in plpgsql function declarations

2005-12-04 Thread Tom Lane
"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.

Re: [GENERAL] Use of %ROWTYPE in plpgsql function declarations

2005-12-03 Thread Karl O. Pinc
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.

Re: [GENERAL] Use of %ROWTYPE in plpgsql function declarations

2005-12-03 Thread Tom Lane
"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 -