| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | "Dickson S(dot) Guedes" <listas(at)guedesoft(dot)net> |
| Cc: | pg-dev <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [RFC] allow 'semester' in functions EXTRACT, DATE_PART, TO_CHAR and so on. |
| Date: | 2015-08-15 00:40:34 |
| Message-ID: | CAKFQuwb=MsY1b7vvwj-3kRXCqyNDCX3SnHd_XX1c6Sr2yF-LZw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Friday, August 14, 2015, Dickson S. Guedes <listas(at)guedesoft(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dickson S. Guedes | 2015-08-15 01:06:22 | Re: [RFC] allow 'semester' in functions EXTRACT, DATE_PART, TO_CHAR and so on. |
| Previous Message | Gavin Flower | 2015-08-15 00:32:44 | Re: [RFC] allow 'semester' in functions EXTRACT, DATE_PART, TO_CHAR and so on. |