Postgres Pro
Downloads
Home   >   mailing lists

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

From Don Morrison
Subject Re: Use of !~* to keep a varchar column UNIQUE case-insensitive
Date
Msg-id aee6519f0608181104g5089dceq5bdb1856261a5430@mail.gmail.com
Whole thread Raw
In response to Re: Use of !~* to keep a varchar column UNIQUE case-insensitive  ("Don Morrison" <donmorrison@gmail.com>)
List pgsql-novice
Tree view 
> 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. >:)

pgsql-novice by date:

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