| From: | Thomas F(dot)O'Connell <tfo(at)sitening(dot)com> |
|---|---|
| To: | Kris Jurka <books(at)ejurka(dot)com> |
| Cc: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>, pgsql-docs(at)postgresql(dot)org |
| Subject: | Re: EXTRACT Clarification |
| Date: | 2004-09-29 13:34:11 |
| Message-ID: | 3F6F3A66-121C-11D9-8537-000D93AE0944@sitening.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-09-29 15:32:24 | Re: EXTRACT Clarification |
| Previous Message | Kris Jurka | 2004-09-29 13:25:59 | Re: EXTRACT Clarification |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Graeme Hinchliffe | 2004-09-29 15:03:53 | string is sometimes null ? |
| Previous Message | Kris Jurka | 2004-09-29 13:25:59 | Re: EXTRACT Clarification |