In-Reply-To: <Pine.BSO.4.56.0409290825020.14292@leary.csoft.net>
References: <DD3C2AD6-11C9-11D9-8537-000D93AE0944@sitening.com>
	<20040928222637.L43334@megazone.bigpanda.com>
	<0E177963-1214-11D9-8537-000D93AE0944@sitening.com>
	<Pine.BSO.4.56.0409290825020.14292@leary.csoft.net>
Mime-Version: 1.0 (Apple Message framework v619)
Content-Type: text/plain; charset=US-ASCII; format=flowed
Message-Id: <3F6F3A66-121C-11D9-8537-000D93AE0944@sitening.com>
Content-Transfer-Encoding: 7bit
Cc: Stephan Szabo <sszabo@megazone.bigpanda.com>,
	pgsql-docs@postgresql.org
From: Thomas F.O'Connell <tfo@sitening.com>
Subject: Re: EXTRACT Clarification
Date: Wed, 29 Sep 2004 09:34:11 -0400
To: Kris Jurka <books@ejurka.com>

It seems like it would be worth noting these (and any others) in the 
docs in some way. Is there a way for someone without a copy of the spec 
to be aware of which are functions and which are not, otherwise?

-tfo

On Sep 29, 2004, at 9:25 AM, Kris Jurka wrote:

> On Wed, 29 Sep 2004, Thomas F.O'Connell wrote:
>
>> Note: EXTRACT is not a true function. SQL defines it as an expression
>> that happens to look similar to a function call.
>>
>> Also, are there other expressions that fall into this category? I 
>> don't
>> know the spec well enough to know.
>
> At least COALESCE and NULLIF are not functions.
>
> Kris Jurka