Postgres Pro
Downloads
Home   >   mailing lists

Re: [RFC] allow 'semester' in functions EXTRACT, DATE_PART, TO_CHAR and so on. - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: [RFC] allow 'semester' in functions EXTRACT, DATE_PART, TO_CHAR and so on.
Date
Msg-id CAKFQuwb=MsY1b7vvwj-3kRXCqyNDCX3SnHd_XX1c6Sr2yF-LZw@mail.gmail.com
Whole thread Raw
In response to [RFC] allow 'semester' in functions EXTRACT, DATE_PART, TO_CHAR and so on.  ("Dickson S. Guedes" <listas@guedesoft.net>)
Responses Re: [RFC] allow 'semester' in functions EXTRACT, DATE_PART, TO_CHAR and so on.  ("Dickson S. Guedes" <listas@guedesoft.net>)
Re: [RFC] allow 'semester' in functions EXTRACT, DATE_PART, TO_CHAR and so on.  (Robert Haas <robertmhaas@gmail.com>)
Re: [RFC] allow 'semester' in functions EXTRACT, DATE_PART, TO_CHAR and so on.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view

On Friday, August 14, 2015, Dickson S. Guedes <listas@guedesoft.net> wrote:

The term is used in a school or college to represent a half-year.
Actually it could be evaluated from a date using some math with
'quarter' but could not be extracted from date since the API to define
a "reserved word" for EXTRACT is in the core, rather than in SQL.


If this is wanted a more consistent word would be "half" since we already accept quarter.

I quite dislike semester because of its connotations in education and the fact that actual semesters do not align with calendar halves.

Tbh, "quarter in (1,2)" does not seem that problematic...

David J.

pgsql-hackers by date:

Previous
From: Gavin Flower
Date:
Subject: Re: [RFC] allow 'semester' in functions EXTRACT, DATE_PART, TO_CHAR and so on.
Next
From: "Dickson S. Guedes"
Date:
Subject: Re: [RFC] allow 'semester' in functions EXTRACT, DATE_PART, TO_CHAR and so on.