Re: doubts about a constraint's definition - Mailing list pgsql-general

From Tom Lane
Subject Re: doubts about a constraint's definition
Date
Msg-id 12669.1048259523@sss.pgh.pa.us
Whole thread Raw
In response to doubts about a constraint's definition  ("enediel" <enediel@com.ith.tur.cu>)
List pgsql-general
"enediel" <enediel@com.ith.tur.cu> writes:
> I need to create a column, where the information is conserved in the same
> way that it was written by the user, but the data of this column is unique
> if it's only taken to capital

CREATE UNIQUE INDEX foo ON tab (UPPER(column));

            regards, tom lane

pgsql-general by date:

Previous
From: "enediel"
Date:
Subject: Re: doubts about a constraint's definition
Next
From: Fernando Schapachnik
Date:
Subject: Posts get losts