Skip site navigation (1) Skip section navigation (2)

Re: WITH RECUSIVE patches 0723

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: WITH RECUSIVE patches 0723
Date: 2008-07-28 19:35:26
Message-ID: 87iqupredd.fsf@news-spur.riddles.org.uk (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
>>>>> "Tom" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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)

In response to

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2008-07-28 19:42:40
Subject: Re: Do we really want to migrate plproxy and citext into PG core distribution?
Previous:From: Tom LaneDate: 2008-07-28 19:29:26
Subject: Re: Do we really want to migrate plproxy and citext into PG core distribution?

pgsql-patches by date

Next:From: Gregory StarkDate: 2008-07-28 20:30:13
Subject: Re: WITH RECUSIVE patches 0723
Previous:From: Tom LaneDate: 2008-07-28 19:15:13
Subject: Re: WITH RECUSIVE patches 0723

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group