X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 03DC732A141 for ; Wed, 29 Sep 2004 16:40:21 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 89845-06 for ; Wed, 29 Sep 2004 15:40:11 +0000 (GMT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id 6D2F232A13B for ; Wed, 29 Sep 2004 16:40:11 +0100 (BST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 5FD233567E; Wed, 29 Sep 2004 08:40:10 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 5DFAA3551B; Wed, 29 Sep 2004 08:40:10 -0700 (PDT) Date: Wed, 29 Sep 2004 08:40:10 -0700 (PDT) From: Stephan Szabo To: Tom Lane Cc: "Thomas F.O'Connell" , pgsql-docs@postgresql.org Subject: Re: EXTRACT Clarification In-Reply-To: <29367.1096471944@sss.pgh.pa.us> Message-ID: <20040929083745.L61021@megazone.bigpanda.com> References: <20040928222637.L43334@megazone.bigpanda.com> <0E177963-1214-11D9-8537-000D93AE0944@sitening.com> <29367.1096471944@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/2 X-Sequence-Number: 2571 On Wed, 29 Sep 2004, Tom Lane wrote: > "Thomas F.O'Connell" writes: > > I'm thinking something like this (with thanks to Stephan): > > > Note: EXTRACT is not a true function. SQL defines it as an expression > > that happens to look similar to a function call. > > Rather than documenting this, maybe we should change the grammar to > allow it? That would work, but presumably then we should be doing all the function looking things, so probably CAST, EXTRACT, OVERLAY, POSITION, SUBSTRING, TREAT, TRIM, CONVERT (and any, if any, that weren't in the section of the grammar I saw those).