Skip site navigation (1) Skip section navigation (2)

Re: Eurodates by default

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Thomas Lockhart <thomas(at)fourpalms(dot)org>
Cc: Yury Bokhoncovich <byg(at)center-f1(dot)ru>,Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Eurodates by default
Date: 2002-03-20 04:32:54
Message-ID: Pine.LNX.4.30.0203192328480.824-100000@peter.localdomain (view raw, whole thread or download thread mbox)
Lists: pgsql-patches
Thomas Lockhart writes:

> But I'm afraid I'm not recalling the specific issues associated with GUC
> vs no-GUC. What in the current behavior of date and time needs to
> change? Is it locale issues (which for non-ISO date input and output is
> a can of worms by itself) or something else?

One issues was that the semantics of DateStyle don't fit well into GUC.
DateStyle takes one or two strings and sets one or two integer variables.
GUC basically only supports once argument setting one variable of equal
type.  It can probably still be made to work with all the hooks that are
in place, but it doesn't look pretty.

I had once suggested splitting up DateStyle into two variables, one for
the "style" and for the day/month order.  I think this is ultimately
clearer to the user, too.

Others have suggested generalizing the "style" aspect to take a to_char
format.  This comes with its own set of problems.

Peter Eisentraut   peter_e(at)gmx(dot)net

In response to


pgsql-patches by date

Next:From: Tom LaneDate: 2002-03-20 05:27:28
Subject: Re: [HACKERS] Fixes gram.y
Previous:From: Thomas LockhartDate: 2002-03-20 03:58:23
Subject: Re: Eurodates by default

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group