Received: from alf.zfn.uni-bremen.de (alf.zfn.uni-bremen.de [134.102.20.22]) by hub.org (8.9.2/8.9.1) with ESMTP id DAA02712 for ; Tue, 9 Mar 1999 03:37:29 -0500 (EST) (envelope-from umehlig@uni-bremen.de) Received: from pandora3.uni-bremen.de (umehlig@moritz21.zfn.uni-bremen.de [134.102.6.61]) by alf.zfn.uni-bremen.de (8.9.1a/ZfNServer) with ESMTP id JAA26020; Tue, 9 Mar 1999 09:33:56 +0100 Received: (from umehlig@localhost) by pandora3.uni-bremen.de (8.9.1/8.9.1) id JAA01608; Tue, 9 Mar 1999 09:38:58 +0100 Date: Tue, 9 Mar 1999 09:38:58 +0100 From: Ulf Mehlig Message-Id: <199903090838.JAA01608@pandora3.uni-bremen.de> X-Authentication-Warning: pandora3.uni-bremen.de: umehlig set sender to umehlig@pandora3.uni-bremen.de using -f To: eg@tzv.fal.de CC: pgsql-interfaces@postgreSQL.org In-reply-to: <9903090816180D.00675@salo.tzv.fal.de> (eg@tzv.fal.de) Subject: Re: [INTERFACES] Bug in sortin routine? References: <9903090816180D.00675@salo.tzv.fal.de> Eilert Groeneveld wrote: > [...] 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); if that is true, the lines are ordered as they should be. If some of the date values appear to be "correct" after manual/visual control and others not, you maybe have inserted some of the values with American, others with German format in use, resulting in a messed up table (and you'll have to fix it by hand). Are you sure you've really set DateStyle correctly? I have something like PGDATESTYLE=German export PGDATESTYLE in my shell's .bashrc, and selecting some date values from one of my tables gives e.g. datum ---------- 16.08.1996 17.08.1996 18.08.1996 19.08.1996 20.08.1996 that is, DD.MM.YYYY (for testing, dates with 'day' after the 12th of the month are better suited than the others ;-). If you set PGDATESTYLE like I did, are you sure the configuration file got source'd? You can test the state of DateStyle with xxx=> show datestyle; NOTICE: DateStyle is German with European conventions SHOW VARIABLE from inside psql. Hope it helps ... viele Grüße, Ulf -- ====================================================================== Ulf Mehlig Center for Tropical Marine Ecology/ZMT, Bremen, Germany ----------------------------------------------------------------------