X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 208385E4077 for ; Fri, 6 Aug 2004 12:30:34 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 01772-03 for ; Fri, 6 Aug 2004 15:30:36 +0000 (GMT) Received: from host4.ccw.gov.uk (host4.ccw.gov.uk [62.3.229.112]) by svr1.postgresql.org (Postfix) with ESMTP id 96CC15E46C2 for ; Fri, 6 Aug 2004 12:30:24 -0300 (ADT) Received: from host3.ccw.gov.uk ([192.168.253.7] helo=host3.hq.ccw.gov.uk) by host4.ccw.gov.uk with esmtp (Exim 4.20) id 1Bt6Jt-0001y2-T2 for pgsql-sql@postgresql.org; Fri, 06 Aug 2004 16:07:45 +0100 Received: from groupwise.ccw.gov.uk ([192.168.24.30]) by host3.hq.ccw.gov.uk with esmtp (Exim 4.14) id 1Bt72k-0004Eg-AV for pgsql-sql@postgresql.org; Fri, 06 Aug 2004 16:54:06 +0100 Received: from CCW_Gateways-MTA by groupwise.ccw.gov.uk with Novell_GroupWise; Fri, 06 Aug 2004 16:29:28 +0100 Message-Id: X-Mailer: Novell GroupWise Internet Agent 6.0.4 Date: Fri, 06 Aug 2004 16:29:19 +0100 From: "Gordon Ross" To: Subject: Make a column case insensitive Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/40 X-Sequence-Number: 18537 Is it possible to make a column case insensitive, without having to pepper = your SELECTs with lots of lower() function calls (and forgetting to do it a= t times !) (I'm on 7.4.3) Thanks, GTG Gordon Ross, Network Manager/Rheolwr Rhydwaith Countryside Council for Wales/Cyngor Cefn Gwlad Cymru