Re: [RFC] allow 'semester' in functions EXTRACT, DATE_PART, TO_CHAR and so on.

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [RFC] allow 'semester' in functions EXTRACT, DATE_PART, TO_CHAR and so on.
Дата
Msg-id CAKFQuwb=MsY1b7vvwj-3kRXCqyNDCX3SnHd_XX1c6Sr2yF-LZw@mail.gmail.com
обсуждение исходный текст
Ответ на [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.  ("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>)
Список pgsql-hackers
Дерево обсуждения

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 по дате отправления:

Предыдущее
От: Gavin Flower
Дата:
Сообщение: Re: [RFC] allow 'semester' in functions EXTRACT, DATE_PART, TO_CHAR and so on.
Следующее
От: "Dickson S. Guedes"
Дата:
Сообщение: Re: [RFC] allow 'semester' in functions EXTRACT, DATE_PART, TO_CHAR and so on.