Skip site navigation (1) Skip section navigation (2)

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

From: "Don Morrison" <donmorrison(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Use of !~* to keep a varchar column UNIQUE case-insensitive
Date: 2006-08-18 20:32:55
Message-ID: aee6519f0608181332gb13a93m814c258d03fcfb2e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
> > 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.

Thanks very much Tom, I realized something was wrong after I posted
again, but decided to refrain from posting again to reduce my "noise".
:)

In response to

pgsql-novice by date

Next:From: Arthur BaldwinDate: 2006-08-18 20:35:44
Subject: Beginner needs example pg_hba.conf
Previous:From: Don MorrisonDate: 2006-08-18 20:30:19
Subject: Re: Use of !~* to keep a varchar column UNIQUE

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group