ONLY - Mailing list pgsql-hackers

From Chris Bitmead
Subject ONLY
Date
Msg-id 389E530C.7FA60CCA@nimrod.itg.telecom.com.au
Whole thread Raw
Responses Re: [HACKERS] ONLY
Re: [HACKERS] ONLY
List pgsql-hackers
Been trying to read the SQL3 draft. My best guess is that this
is the appropriate section...
            Let T be the table identified by           <ANSI>  <table name>           <ISO >  <table or query name>
     contained in a <table specification> TS.
 

...
          c) If ONLY is specified, then TS identifies a table fo the
rows             that do not have any corresponding row in any subtable of             T.

I assume this a round-about way of saying that "ONLY" is used to exclude
subtables?

BTW, I think in SQL3 the oid column is supposed to be called "IDENTITY".
Maybe, but who can read this thing? (Can we find the people who wrote
this document and have them taken out and flogged?).


pgsql-hackers by date:

Previous
From:
Date:
Subject: Re: [SQL] Re: [HACKERS] Proposed Changes to PostgreSQL
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] DISTINCT and ORDER BY bug?