| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)2ndquadrant(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:09:05 |
| Message-ID: | 555EABE1.8050408@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 05/21/2015 09:04 PM, Alvaro Herrera wrote:
> 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.
Probably so, but the output is a lot cleaner then what I did in psql.
The author of pgFormatter will be interested in your comments:
https://github.com/darold/pgFormatter
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2015-05-22 04:55:40 | Re: Strange replication problem - segment restored from archive but still requested from master |
| Previous Message | Alvaro Herrera | 2015-05-22 04:04:27 | Re: date with month and year |