Postgres Pro
Downloads
Home   >   mailing lists

Re: How to create case insensitive unique constraint - Mailing list pgsql-general

From Andrus
Subject Re: How to create case insensitive unique constraint
Date
Msg-id dgs7qs$1us6$1@news.hub.org
Whole thread Raw
In response to How to create case insensitive unique constraint  ("Andrus" <eetasoft@online.ee>)
List pgsql-general
Tree view 
> 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.

pgsql-general by date:

Previous
From: "John D. Burger"
Date:
Subject: Re: How to create case insensitive unique constraint
Next
From: Steve Manes
Date:
Subject: Fetching column names for a table