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