Received: from golem.jpl.nasa.gov (IDENT:root@hectic-2.jpl.nasa.gov
	[128.149.68.204]) by hub.org (8.9.2/8.9.1) with ESMTP id KAA49239
	for <pgsql-interfaces@postgreSQL.org>;
	Tue, 9 Mar 1999 10:13:42 -0500 (EST)
	(envelope-from lockhart@alumni.caltech.edu)
Received: from alumni.caltech.edu (localhost [127.0.0.1])
	by golem.jpl.nasa.gov (8.8.5/8.8.5) with ESMTP id PAA10107;
	Tue, 9 Mar 1999 15:08:06 GMT
Sender: tgl@mythos.jpl.nasa.gov
Message-ID: <36E53955.6655F50@alumni.caltech.edu>
Date: Tue, 09 Mar 1999 15:08:05 +0000
From: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Organization: Caltech/JPL
X-Mailer: Mozilla 4.07 [en] (X11; I; Linux 2.0.36 i686)
MIME-Version: 1.0
To: Ulf Mehlig <umehlig@uni-bremen.de>
CC: eg@tzv.fal.de, pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Bug in sortin routine?
References: <9903090816180D.00675@salo.tzv.fal.de>
	<199903090838.JAA01608@pandora3.uni-bremen.de>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

> > [...] 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