Re: [INTERFACES] Bug in sortin routine?

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: Ulf Mehlig <umehlig(at)uni-bremen(dot)de>
Cc: eg(at)tzv(dot)fal(dot)de, pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] Bug in sortin routine?
Date: 1999-03-09 15:08:05
Message-ID: 36E53955.6655F50@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 1999-03-09 15:08:57 Re: [INTERFACES] Getting field length in libpq
Previous Message Bartek Teodorczyk 1999-03-09 14:44:57 Getting field length in libpq