X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (developer.postgresql.org [64.117.224.193])
	by developer.postgresql.org (Postfix) with ESMTP id B579E92542E
	for <pgsql-sql@postgresql.org>; Fri, 23 May 2003 14:25:50 -0400 (EDT)
Received: from developer.postgresql.org ([64.117.224.193])
	by localhost (developer.postgresql.org [64.117.224.193:10024])
	(amavisd-new) with ESMTP id 61232-10 for <pgsql-sql@postgresql.org>;
	Fri, 23 May 2003 14:25:42 -0400 (EDT)
Received: from davinci.ethosmedia.com (unknown [209.10.40.251])
	by developer.postgresql.org (Postfix) with ESMTP id 14F7A925470
	for <pgsql-sql@postgresql.org>; Fri, 23 May 2003 14:16:17 -0400 (EDT)
Received: from [66.219.92.2] (HELO temoku)
	by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2)
	with ESMTP id 3058904 for pgsql-sql@postgresql.org;
	Fri, 23 May 2003 11:16:20 -0700
Content-Type: text/plain;
  charset="us-ascii"
From: Josh Berkus <josh@agliodbs.com>
Reply-To: josh@agliodbs.com
Organization: Aglio Database Solutions
To: pgsql-sql@postgresql.org
Subject: Bad rowtype on PL/SQL Oracle -- does anyone know?
Date: Fri, 23 May 2003 11:15:47 -0700
User-Agent: KMail/1.4.3
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200305231115.47324.josh@agliodbs.com>
X-Virus-Scanned: by amavisd-new
X-Archive-Number: 200305/475
X-Sequence-Number: 13640

Folks,

We need some help from an active Oracle PL/SQL programmer.

What would Oracle PL/SQL do in this case:

DECLARE some_rec some_table%ROWTYPE

SELECT a, b  --but not c, d
FROM some_table INTO some_rec
WHERE a =3D x;

We're trying to determine what PL/pgSQL should do if given a select stateme=
nt=20
which does not match the declared %ROWTYPE, and were wondering what PL/SQL=
=20
does.  My PL/SQL manual does not make it clear, and I don't have  a running=
=20
8i to test on.

--=20
-Josh Berkus
 Aglio Database Solutions
 San Francisco