Case insensitive unique constraint - Mailing list pgsql-general

From Rob Brenart
Subject Case insensitive unique constraint
Date
Msg-id 42D610C8.3040409@oculardata.com
Whole thread Raw
In response to Re: To Postgres or not  ("Jim C. Nasby" <decibel@decibel.org>)
Responses Re: Case insensitive unique constraint
Re: Case insensitive unique constraint
Re: Case insensitive unique constraint
Re: Case insensitive unique constraint
List pgsql-general
I have a simple table to store account names... I want each name to be
unique in a case insensitive manner... but I want the case the user
enters to be remembered so I can't do a simple lower() on the data's way in.

Is there an easy way to go about this? Am I about to write my first
server side function for postgresql?



pgsql-general by date:

Previous
From: Roman Neuhauser
Date:
Subject: Re: To Postgres or not
Next
From: "Martynas Brijunas"
Date:
Subject: Quotation marks in queries