Re: date with month and year

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: Daniel Torres <nobeeakon(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org, gilles(at)darold(dot)net
Subject: Re: date with month and year
Date: 2015-05-22 04:04:27
Message-ID: 20150522040427.GU5885@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Adrian Klaver wrote:

> SELECT
> extract (
> YEAR
> FROM
> school_day ) AS YEAR,

> Reformatting courtesy of pgFormatter(http://sqlformat.darold.net/).

FWIW I think this indenting of FROM inside an extract() call is odd and
ugly --- probably just an accident resulting from dealing with the
regular FROM clause. It seems to me that the "YEAR FROM school_day"
part should be considered a single argument instead of breaking it in
multiple lines.

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-05-22 04:09:05 Re: date with month and year
Previous Message Adrian Klaver 2015-05-22 02:46:48 Re: date with month and year