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 18:04:08
Message-ID: aee6519f0608181104g5089dceq5bdb1856261a5430@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> create unique index fooi on foo (lower(trim both
> '\040\f\t\r\n\a\b\e\v' from name));

Whoops, I had to shorten that to '\040\f\t\r\n\b'...I was borrowing
from regular expressions again. >:)

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Daniel T. Staal 2006-08-18 18:59:29 Re: Use of !~* to keep a varchar column UNIQUE
Previous Message Don Morrison 2006-08-18 17:52:28 Re: Use of !~* to keep a varchar column UNIQUE case-insensitive