public inbox for [email protected]  

help / color / mirror / Atom feed

From: Thomas F.O'Connell <[email protected]>
To: Tom Lane <[email protected]>
Cc: Stephan Szabo <[email protected]>
Cc: [email protected]
Subject: Re: EXTRACT Clarification
Date: Wed, 29 Sep 2004 11:42:26 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>

That seems reasonable, too, although I was interested to learn that 
this (and a few other expressions) weren't actually functions. Whether 
that's actually meaningful for any implementation purposes is 
debatable.

Even if the grammar is changed to allow it, it's probably worth making 
a note of it in SQL compatibility documentation.

Speaking of which, since functions aren't in the SQL Commands 
reference, where the compatibility documentation resides, does anyone 
see value in adding compatibility information to The SQL Language 
section as a whole?

I can contribute what I know, but I don't have a full copy of the spec.

-tfo

On Sep 29, 2004, at 11:32 AM, Tom Lane wrote:

> "Thomas F.O'Connell" <[email protected]> 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?
>
> 			regards, tom lane

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