Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 21BCD65029E for ; Mon, 28 Jul 2008 17:00:00 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 87328-01 for ; Mon, 28 Jul 2008 16:59:56 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 05FDA650088 for ; Mon, 28 Jul 2008 16:59:59 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.1/8.14.1) with ESMTP id m6SJxtBh087443 for ; Mon, 28 Jul 2008 16:59:55 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.1/8.14.1/Submit) id m6SJZQ8Y063300 for pgsql-hackers@postgresql.org; Mon, 28 Jul 2008 16:35:26 -0300 (ADT) (envelope-from news) From: Andrew Gierth X-Newsgroups: pgsql.hackers Subject: Re: WITH RECUSIVE patches 0723 Date: Mon, 28 Jul 2008 20:35:26 +0100 Organization: disorganised Lines: 16 Message-ID: <87iqupredd.fsf@news-spur.riddles.org.uk> 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> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Cancel-Lock: sha1:+bgihBAbx36qF8JMz2f77qpNjKQ= sha1:JIcEMyTRxc97TaanQqviEOio+2g= User-Agent: Gnus/5.1002 (Gnus v5.10.2) Emacs/22.1 (berkeley-unix) To: pgsql-hackers@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/1323 X-Sequence-Number: 121583 >>>>> "Tom" == Tom Lane 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)