From: Ansgar -59cobalt- Wiechers <lists@planetcobalt.net>
To: pgsql-performance@postgresql.org
Subject: Re: index over timestamp not being used
Date: Wed, 25 Jul 2007 15:35:12 +0200
Message-ID: <20070725133512.GA19159@mail.planetcobalt.net> (raw)
In-Reply-To: <200707251505.11182.mweilguni@sime.com>
References: <46A64475.3040201@andromeiberica.com>
<46A6537B.6010604@andromeiberica.com>
<15140.1185306195@sss.pgh.pa.us>
<200707251505.11182.mweilguni@sime.com>
On 2007-07-25 Mario Weilguni wrote:
> Am Dienstag 24 Juli 2007 schrieb Tom Lane:
>>> I thought the to_char/to_date/to_timestamp functions were intented
>>> for this purposes
>>
>> No, they're intended for dealing with wacky formats that the regular
>> input/output routines can't understand or produce.
>
> Really? I use them alot, because of possible problems with different
> date formats. 20070503 means May 3, 2007 for germans,
Actually, no. 20070503 is the condensed form of the ISO international
calendar date format (see ISO 8601). German formats would be 03.05.2007
or 3. Mai 2007.
Regards
Ansgar Wiechers
--
"The Mac OS X kernel should never panic because, when it does, it
seriously inconveniences the user."
--http://developer.apple.com/technotes/tn2004/tn2118.html
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: lists@planetcobalt.net
Subject: Re: index over timestamp not being used
In-Reply-To: <20070725133512.GA19159@mail.planetcobalt.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox