Re: help with PL/PgSQL bug

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mike Mascari" <mascarm(at)mascari(dot)com>
Cc: "Neil Conway" <neilc(at)samurai(dot)com>, "PostgreSQL Hackers" <pgsql-hackers(at)postgresql(dot)org>, darcy(at)wavefire(dot)com
Subject: Re: help with PL/PgSQL bug
Date: 2003-01-11 07:19:35
Message-ID: 2914.1042269575@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Mike Mascari" <mascarm(at)mascari(dot)com> writes:
>> Does Oracle's PL/SQL have a concept of record variables? If so, what
>> do they do in this situation?

> In Oracle 8, a row of NULLs:

> 1 CREATE OR REPLACE FUNCTION foo(t IN NUMBER)
> 2 RETURN NUMBER
> 3 IS
> 4 emp_rec employees%ROWTYPE;

That's a rowtype variable, though, not a record variable. I believe our
code will work the same as Oracle for that case.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2003-01-11 08:34:01 Re: v7.3.1 psql against a v7.2.x database ...
Previous Message Lamar Owen 2003-01-11 06:20:55 Re: v7.3.1 psql against a v7.2.x database ...