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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general