> > 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 Baldwin||Date: 2006-08-18 20:35:44|
|Subject: Beginner needs example pg_hba.conf|
|Previous:||From: Don Morrison||Date: 2006-08-18 20:30:19|
|Subject: Re: Use of !~* to keep a varchar column UNIQUE|