Home > mailing lists

Re: Case Sensitivity - Mailing list pgsql-general

From	Karsten Hilbert
Subject	Re: Case Sensitivity
Date	January 13, 2011 14:25:38
Msg-id	20110113152528.218550@gmx.net Whole thread Raw
In response to	Re: Case Sensitivity (Pavel Stehule <pavel.stehule@gmail.com>)
List	pgsql-general

Tree view

> 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

pgsql-general by date:

From: Andy Colson
Date: 13 January 2011, 14:24:13
Subject: Re: Spatial data Loading and storing

From: "Phillip Smith"
Date: 13 January 2011, 14:27:26
Subject: Re: Case Sensitivity

Re: Case Sensitivity - Mailing list pgsql-general

Previous

Next