Postgres Pro
Downloads
Home   >   mailing lists

Re: Use of %ROWTYPE in plpgsql function declarations - Mailing list pgsql-general

From Tom Lane
Subject Re: Use of %ROWTYPE in plpgsql function declarations
Date
Msg-id 8248.1133713887@sss.pgh.pa.us
Whole thread Raw
In response to Re: Use of %ROWTYPE in plpgsql function declarations  ("Karl O. Pinc" <kop@meme.com>)
List pgsql-general
Tree view 
"Karl O. Pinc" <kop@meme.com> 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.

            regards, tom lane

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Slow COUNT
Next
From: Tino Wildenhain
Date:
Subject: Re: Slow COUNT