Received: from gabuzo.meunet (IDENT:root@d224.paris-204.cybercable.fr [212.198.204.224]) by hub.org (8.9.3/8.9.1) with ESMTP id OAA38809 for ; Tue, 27 Apr 1999 14:37:43 -0400 (EDT) (envelope-from christophe.labouisse@dial.oleane.com) Received: (from moi@localhost) by gabuzo.meunet (8.9.1a/8.9.1/Christophe Labouisse - 10/01/99) id UAA27986; Tue, 27 Apr 1999 20:35:43 +0200 To: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Strange behavior References: <8381.925223461@sss.pgh.pa.us> Mime-Version: 1.0 (generated by tm-edit 7.108) Content-Type: multipart/mixed; boundary="Multipart_Tue_Apr_27_20:35:43_1999-1" Content-Transfer-Encoding: 7bit From: Christophe Labouisse Date: 27 Apr 1999 20:35:43 +0200 In-Reply-To: Tom Lane's message of "Tue, 27 Apr 1999 10:31:01 -0400" Message-ID: Lines: 40 X-Mailer: Gnus v5.5/XEmacs 20.4 - "Emerald" --Multipart_Tue_Apr_27_20:35:43_1999-1 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Tom Lane writes: > > Well I guess that's it since \377 in fr_FR is ˙ (ydierisis). > > And I suppose that sorts before, or the same as, plain y? Oops. Yep. > > As a temporary measure you could rebuild with USE_LOCALE turned on; > the parser code is set up not to generate the <= clause if that's > defined. But we need a better solution. Hmm that's strange I though I compiled already with locale enabled. Here is the configure line from config.status : # ./configure --with-tcl --with-perl --with-odbc --with-CC=/opt/pgcc/bin/gcc -- with-CXX=/opt/pgcc/bin/g++ --enable-locale That's should be good no ? Anyway I'll check it again. Anyway I think that even without locale this optimization can lead to incorrect result if you have a a field starting with \377. --Multipart_Tue_Apr_27_20:35:43_1999-1 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Christophe Labouisse : Cinéma, typographie, Unix christophe.labouisse@dial.oleane.com http://www.multimania.com/gabuzo/ Le cinéma en Lumičre : http://www.lumiere.org/ --Multipart_Tue_Apr_27_20:35:43_1999-1--