public inbox for [email protected]  
help / color / mirror / Atom feed
From: Thomas F.O'Connell <[email protected]>
To: Kris Jurka <[email protected]>
Cc: Stephan Szabo <[email protected]>
Cc: [email protected]
Subject: Re: EXTRACT Clarification
Date: Wed, 29 Sep 2004 09:34:11 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>

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




view thread (13+ messages)  latest in thread

reply

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: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: EXTRACT Clarification
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox