X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id ABE60476317 for ; Thu, 27 Mar 2003 09:44:51 -0500 (EST) Received: from mail.virginia.edu (mail.Virginia.EDU [128.143.2.9]) by postgresql.org (Postfix) with SMTP id 97B8A47632C for ; Thu, 27 Mar 2003 09:44:50 -0500 (EST) Received: from smtp.mail.virginia.edu by mail.virginia.edu id aa05418; 27 Mar 2003 9:44 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 h2REiph36888; Thu, 27 Mar 2003 09:44:52 -0500 Message-ID: <006c01c2f470$4e8af800$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> <004a01c2f46c$61e15d80$de138f80@virginia.edu> <11335.1048775915@sss.pgh.pa.us> Subject: Re: order by Date: Thu, 27 Mar 2003 09:51:10 -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/617 X-Sequence-Number: 12655 Can I look at this via the command line? within psql? or in one of the .conf files? ----- Original Message ----- From: "Tom Lane" To: "Jodi Kanter" Cc: "Postgres SQL List" Sent: Thursday, March 27, 2003 9:38 AM Subject: Re: [SQL] order by > Jodi Kanter writes: > > When we originally initialized I set the LC_COLLATE=C. Was this not enough? > > Should have been ... but see what pg_controldata says about the actual > setting. > > regards, tom lane >