Re: How to create case insensitive unique constraint

From: "Andrus" <eetasoft(at)online(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to create case insensitive unique constraint
Date: 2005-09-21 18:10:47
Message-ID: dgs7qs$1us6$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> You could use upper() similarly - lower() is better for Unicode data, like
> mine.

John,

thank you. Excellent.
I have database encoding UNICODE. Why lower() is better than upper()?

Andrus.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Manes 2005-09-21 18:31:23 Fetching column names for a table
Previous Message Stas Oskin 2005-09-21 17:51:57 Postgres locks table schema?