Skip site navigation (1) Skip section navigation (2)

Re: EXTRACT Clarification

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Thomas F(dot)O'Connell" <tfo(at)sitening(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 15:32:24
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-docspgsql-general
"Thomas F.O'Connell" <tfo(at)sitening(dot)com> 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

In response to


pgsql-docs by date

Next:From: Stephan SzaboDate: 2004-09-29 15:40:10
Subject: Re: EXTRACT Clarification
Previous:From: Thomas F.O'ConnellDate: 2004-09-29 13:34:11
Subject: Re: EXTRACT Clarification

pgsql-general by date

Next:From: Jonathan VillaDate: 2004-09-29 15:35:43
Subject: Converting to Java date example
Previous:From: Stephan SzaboDate: 2004-09-29 15:09:32
Subject: Re: Setting search paths inside a function (plpgsql)

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group