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

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 02:26:39
Message-ID: CAKFQuwayU7XNaQTWfqbUbcuo1h-+UVVUyvXkZpK8d70=BMBzPA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

​On Fri, Aug 14, 2015 at 6:11 PM, Dickson S. Guedes <listas(at)guedesoft(dot)net>
wrote:

> 2015-08-14 21:40 GMT-03:00 David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>:
> > 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.
>
> In your opinion: "half" or "halfyear" ?
>
>
​We don't say "quarteryear" so there would need to be a compelling argument
for "halfyear" over simply "half"​

​David J.​

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2015-08-15 03:04:43 Re: [RFC] allow 'semester' in functions EXTRACT, DATE_PART, TO_CHAR and so on.
Previous Message Robert Haas 2015-08-15 02:15:30 Re: alter-table-1 isolation test spec contains a duplicate step name