Re: Case Sensitivity

From: "Karsten Hilbert" <Karsten(dot)Hilbert(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Case Sensitivity
Date: 2011-01-13 15:25:28
Message-ID: 20110113152528.218550@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> you should to use a citext datatype
>
> http://www.postgresql.org/docs/9.0/interactive/citext.html

Or:

- use a functional index with lower() to ensure uniqueness
- use a BEFORE trigger to lower() the inserted data

Karsten

--
GMX DSL Doppel-Flat ab 19,99 Euro/mtl.! Jetzt mit
gratis Handy-Flat! http://portal.gmx.net/de/go/dsl

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Phillip Smith 2011-01-13 15:29:03 Re: Case Sensitivity
Previous Message Phillip Smith 2011-01-13 15:25:01 Re: Case Sensitivity