Re: Use of %ROWTYPE in plpgsql function declarations

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Karl O(dot) Pinc" <kop(at)meme(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Use of %ROWTYPE in plpgsql function declarations
Date: 2005-12-04 16:31:27
Message-ID: 8248.1133713887@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Karl O. Pinc" <kop(at)meme(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2005-12-04 17:28:53 Re: Slow COUNT
Previous Message Bruno Wolff III 2005-12-04 15:56:16 Re: Slow COUNT