X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 4F5554758C9 for ; Thu, 27 Mar 2003 09:16:45 -0500 (EST) Received: from mail.virginia.edu (mail.Virginia.EDU [128.143.2.9]) by postgresql.org (Postfix) with SMTP id 66F1247580B for ; Thu, 27 Mar 2003 09:16:44 -0500 (EST) Received: from smtp.mail.virginia.edu by mail.virginia.edu id aa06889; 27 Mar 2003 9:16 EST Received: from jlk3xpc (d-128-19-222.bootp.Virginia.EDU [128.143.19.222]) by smtp.mail.Virginia.EDU (8.11.6p/8.11.6) with SMTP id h2REGkh07160; Thu, 27 Mar 2003 09:16:46 -0500 Message-ID: <004a01c2f46c$61e15d80$de138f80@virginia.edu> From: Jodi Kanter To: Tom Lane Cc: Postgres SQL List References: <002701c2f3be$880749b0$de138f80@virginia.edu> <9613.1048748250@sss.pgh.pa.us> Subject: Re: order by Date: Thu, 27 Mar 2003 09:23:05 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Spam-Status: No, hits=-19.1 required=5.0 tests=BAYES_20,ORIGINAL_MESSAGE,QUOTED_EMAIL_TEXT,REFERENCES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200303/615 X-Sequence-Number: 12653 When we originally initialized I set the LC_COLLATE=C. Was this not enough? We set it in the environment variables for the postgres user. Thanks Jodi ----- Original Message ----- From: "Tom Lane" To: "Jodi Kanter" Cc: "Postgres SQL List" Sent: Thursday, March 27, 2003 1:57 AM Subject: Re: [SQL] order by > Jodi Kanter writes: > > Is there a known problem with the SQL order by clause within postgres versi= > > on 7.2.3? > > No ... but it does honor the sorting rules of the locale you initialize > the database in. You might want to re-initdb with LC_ALL set to C. > > regards, tom lane >