Re: A creepy story about dates. How to prevent it? - Mailing list pgsql-general

From Joel Rees
Subject Re: A creepy story about dates. How to prevent it?
Date
Msg-id 20030623150641.243F.JOEL@alpsgiken.gr.jp
Whole thread Raw
In response to Re: A creepy story about dates. How to prevent it?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
> Is it
> desiarable to default postgresql.conf datestyle to match the locale?
>
>     #
>     #       Locale settings
>     #
>     # (initialized by initdb -- may be changed)
>     LC_MESSAGES = 'C'
>     LC_MONETARY = 'C'
>     LC_NUMERIC = 'C'
>     LC_TIME = 'C'

Another JPY 2 from the nattou gallery:

Defaulting the datestyle to the locale setting makes sense to me. I
wouldn't want it hardwired to the locale, of course.

I would strongly request having heuristics off in the default settings.

Two conditions I really want on the use of heuristics -- I want the date
itself to include some "fuzzy" flag, and I want some way to reconstruct
the original string. That way, if I want to design an application with
tools for getting operator attention, etc., there are hooks in the data.
But that feels to me like something for the application layer.

--
Joel Rees, programmer, Kansai Systems Group
Altech Corporation (Alpsgiken), Osaka, Japan
http://www.alpsgiken.co.jp


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Thousands of semops for every i/o
Next
From: Michael Meskes
Date:
Subject: Re: [pgsql-advocacy] MySQL gets $19.5 MM