Postgres Pro
Downloads
Home   >   mailing lists

Re: Use of !~* to keep a varchar column UNIQUE case-insensitive - Mailing list pgsql-novice

From Tom Lane
Subject Re: Use of !~* to keep a varchar column UNIQUE case-insensitive
Date
Msg-id 24422.1155931444@sss.pgh.pa.us
Whole thread Raw
In response to Re: Use of !~* to keep a varchar column UNIQUE case-insensitive  ("Don Morrison" <donmorrison@gmail.com>)
Responses Re: Use of !~* to keep a varchar column UNIQUE case-insensitive  ("Don Morrison" <donmorrison@gmail.com>)
List pgsql-novice
Tree view 
"Don Morrison" <donmorrison@gmail.com> writes:
> create unique index fooi on foo (lower(substring(name FROM '^\s*(\S*)\s*$')));

> but (at least in postgres 7.4.13) the use of substring doesn't
> work...

You need to double those backslashes.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Daniel T. Staal"
Date:
Subject: Re: Use of !~* to keep a varchar column UNIQUE
Next
From: "Don Morrison"
Date:
Subject: Re: Use of !~* to keep a varchar column UNIQUE