Re: date with month and year

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.klaver@aklaver.com