From: Andrew Gierth <andrew@tao11.riddles.org.uk>
To: pgsql-hackers@postgresql.org
Subject: Re: WITH RECUSIVE patches 0723
Date: Mon, 28 Jul 2008 20:35:26 +0100
Message-ID: <87iqupredd.fsf@news-spur.riddles.org.uk> (raw)
References: <20080725001513.GF16438@fetter.org>
<20080725.092652.105178884.t-ishii@sraoss.co.jp>
<87r69gs967.fsf@news-spur.riddles.org.uk>
<20080728.162925.23020498.t-ishii@sraoss.co.jp>
<19882.1217256991@sss.pgh.pa.us>
<87myk1rg4z.fsf@news-spur.riddles.org.uk>
<26270.1217272513@sss.pgh.pa.us>
>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:
Tom> We are not in the business of getting spec-required semantics
Tom> 80% right;
I guess that's why we still fold identifiers to lowercase, why our
timestamp implementation differs from the standard, why we used to
require AS for select-list aliases, why our views aren't updateable,
why we violate the spec for UNIQUE, why we don't have schema-unique
constraint names, why we don't implement MATCH PARTIAL, ...
The SQL spec is a Platonic ideal to which _none_ of the implementations
are more than a vague approximation.
--
Andrew (irc:RhodiumToad)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-patches@postgresql.org
Cc: andrew@tao11.riddles.org.uk, pgsql-hackers@postgresql.org
Subject: Re: WITH RECUSIVE patches 0723
In-Reply-To: <87iqupredd.fsf@news-spur.riddles.org.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox