Postgres Pro
Downloads
Home   >   mailing lists

Re: Use of !~* to keep a varchar column UNIQUE case-insensitive - Mailing list pgsql-novice

From Tom Lane
Subject Re: Use of !~* to keep a varchar column UNIQUE case-insensitive
Date
Msg-id 21447.1155919683@sss.pgh.pa.us
Whole thread Raw
In response to Use of !~* to keep a varchar column UNIQUE case-insensitive  ("Don Morrison" <donmorrison@gmail.com>)
Responses Re: Use of !~* to keep a varchar column UNIQUE case-insensitive  ("Don Morrison" <donmorrison@gmail.com>)
List pgsql-novice
Tree view 
"Don Morrison" <donmorrison@gmail.com> writes:
> Has anyone come up with a way, or ways to trim leading and trailing
> whitespace, then do a case-insensitive uniqueness check efficiently
> and semi-elegantly?

Use a unique functional index, eg this handles the case sensitivity
issue:

    create unique index fooi on foo (lower(name));

Suppressing whitespace is left as an exercise for the reader...

            regards, tom lane

pgsql-novice by date:

Previous
From: Sean Davis
Date:
Subject: Re: Use of !~* to keep a varchar column UNIQUE
Next
From: "Don Morrison"
Date:
Subject: Re: Use of !~* to keep a varchar column UNIQUE case-insensitive