From: Eildert Groeneveld <eg@tzv.fal.de>
To: 'pgsql-interfaces@postgresql.org' <pgsql-interfaces@postgresql.org>
Subject: Bug in sortin routine?
Date: Tue, 9 Mar 1999 08:04:10 +0100
Message-ID: <9903090816180D.00675@salo.tzv.fal.de> (raw)
Hello everyone,
I am not sure if this is the appropriate mailing lists. But lets try
anyway.
It seems that the sorting order on dates is incorrect under certain
circumstances:
The query :
select tdat
from quick
where empfang like 'HUK-COBURG VERS.-GRUPPE' and
zweck like 'BEITRAG F. 300/338958-M PFLEGEPFLICHTVERSICHERUNG'
and date_part ('year',tdat::datetime)=1997
order by tdat;
produces:
tdat
----------
1997-01-04
1997-01-08
1997-01-09
1997-01-10
1997-01-12
1997-02-01
1997-02-05
1997-02-06
1997-02-07
1997-03-02
1997-03-03
1997-03-11
(12 rows)
while this gives the correct sort order:
select tdat
from quick
order by tdat;
1997-11-26
1997-11-27
1997-11-27
1997-11-27
1997-11-28
1997-11-28
1997-11-28
1997-12-03
1997-12-05
1997-12-05 (just a section)
any idea of what may be going on?
set DateStyle to 'German'; (does not have an effect on the problem)
postgresql-6.4.2-2
readhat 5.2
greetings
Eildert Groeneveld
=========================================
Institute for
Animal Science and Animal Behaviour
Mariensee 31535 Neustadt Germany
Tel : (49)(0)5034 871155
Fax : (49)(0)5034 92579
www : http://www.tzv.fal.de/~eg/
e-mail: eg@tzv.fal.de
=========================================
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: eg@tzv.fal.de
Subject: Re: Bug in sortin routine?
In-Reply-To: <9903090816180D.00675@salo.tzv.fal.de>
* 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