From: Thomas G. Lockhart <lockhart@alumni.caltech.edu>
To: Ulf Mehlig <umehlig@uni-bremen.de>
Cc: eg@tzv.fal.de
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Bug in sortin routine?
Date: Tue, 09 Mar 1999 15:08:05 +0000
Message-ID: <36E53955.6655F50@alumni.caltech.edu> (raw)
References: <9903090816180D.00675@salo.tzv.fal.de>
<199903090838.JAA01608@pandora3.uni-bremen.de>
> > [...] It seems that the sorting order on dates is incorrect under
> > certain circumstances: [...] set DateStyle to 'German'; (does not
> > have an effect on the problem) [...]
> From the examples you gave it appears that you are still using
> American date format (YYYY-MM-DD)
An irrelevant detail: the YYYY-MM-DD date format is ISO-8601, and is not
particularly common in America. The US style looks like MM/DD/YYYY.
I think your analysis and recommendations are correct; the sort order in
the example looked good to me too...
- Tom
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-interfaces@postgresql.org
Cc: lockhart@alumni.caltech.edu, umehlig@uni-bremen.de, eg@tzv.fal.de
Subject: Re: [INTERFACES] Bug in sortin routine?
In-Reply-To: <36E53955.6655F50@alumni.caltech.edu>
* 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