Make a column case insensitive

From: "Gordon Ross" <G(dot)Ross(at)ccw(dot)gov(dot)uk>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Make a column case insensitive
Date: 2004-08-06 15:29:19
Message-ID: s113b1e8.083@groupwise.ccw.gov.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 at times !)

(I'm on 7.4.3)

Thanks,

GTG

Gordon Ross,
Network Manager/Rheolwr Rhydwaith
Countryside Council for Wales/Cyngor Cefn Gwlad Cymru

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Sascha Ziemann 2004-08-06 18:25:02 UNIQUE constraint
Previous Message Tom Lane 2004-08-06 14:30:06 Re: SQL syntax extentions - to put postgres ahead in the race