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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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