ONLY

From: Chris Bitmead <chrisb(at)nimrod(dot)itg(dot)telstra(dot)com(dot)au>
To: "pgsql-hackers(at)postgreSQL(dot)org" <pgsql-hackers(at)postgreSQL(dot)org>
Subject: ONLY
Date: 2000-02-07 05:07:24
Message-ID: 389E530C.7FA60CCA@nimrod.itg.telecom.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?).

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-02-07 05:26:04 Re: [HACKERS] DISTINCT and ORDER BY bug?
Previous Message Tom Lane 2000-02-07 05:00:59 Re: [HACKERS] Advice needed,