Postgres Pro
Downloads
Home   >   mailing lists

Re: How can unique columns being case-insensitive be accomplished? - Mailing list pgsql-sql

From Tom Lane
Subject Re: How can unique columns being case-insensitive be accomplished?
Date
Msg-id 26275.1032183526@sss.pgh.pa.us
Whole thread Raw
In response to How can unique columns being case-insensitive be accomplished?  ("Jörg" <mail2holly@gmx.de>)
Responses Re: How can unique columns being case-insensitive be accomplished?
List pgsql-sql
Tree view 
"J�rg" <mail2holly@gmx.de> writes:
> How can this problem be overcome? Any ideas?

Create a unique index on lower(name).
        regards, tom lane

pgsql-sql by date:

Previous
From: jlparkinson@bigpond.com
Date:
Subject: Re: Slow Multi-joins performance [DEVELOPERS attn please]
Next
From: "Michael Paesold"
Date:
Subject: Re: does table names have a format and size