Received: from cygnus.com (runyon.sfbay.redhat.com [205.180.230.5] (may be forged)) by postgresql.org (8.11.3/8.11.4) with SMTP id g0NLvFl45904 for ; Wed, 23 Jan 2002 16:57:15 -0500 (EST) (envelope-from fnasser@redhat.com) Received: from redhat.com (totem.toronto.redhat.com [172.16.14.242]) by runyon.cygnus.com (8.8.7-cygnus/8.8.7) with ESMTP id NAA18180; Wed, 23 Jan 2002 13:57:09 -0800 (PST) Message-ID: <3C4F31B4.C7C9B2D6@redhat.com> Date: Wed, 23 Jan 2002 16:57:08 -0500 From: Fernando Nasser Organization: Red Hat , Inc. - Toronto X-Mailer: Mozilla 4.78 [en] (X11; U; Linux 2.4.7-10smp i686) X-Accept-Language: en MIME-Version: 1.0 To: Tom Lane CC: Zeugswetter Andreas SB SD , pgsql-hackers@postgresql.org Subject: Re: Schemas vs. PostQUEL: resolving qualified identifiers References: <46C15C39FEB2C44BA555E356FBCD6FA42128D9@m0114.s-mxs.net> <2521.1011798379@sss.pgh.pa.us> <3C4EFD15.882B0785@redhat.com> <4503.1011812400@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200201/1089 X-Sequence-Number: 18069 Tom Lane wrote: > > Fernando Nasser writes: > > Tom Lane wrote: > >> Okay, but then how will you refer unambiguously to the rowtype object? > > > What about casting with the keyord ROW? > > func(ROW table) > > always refers to the row-type of table "table" even if there is > > a column called "table". > > Strikes me as gratuituously different from the way everything else is > done. We have .* and %ROWTYPE and so forth, and they're all suffixes. > The closest analogy to your ROW syntax is CAST, but it doesn't alter the > initial interpretation of its argument. > I didn't mean literally that way, I just wanted to add a keyword for solving ambiguity (when there is one). You are right, it should be: func(table%ROWTYPE) -- Fernando Nasser Red Hat - Toronto E-Mail: fnasser@redhat.com 2323 Yonge Street, Suite #300 Toronto, Ontario M4P 2C9