On 2011-01-14, Susanne Ebrecht <susanne(at)2ndQuadrant(dot)com> wrote:
> CREATE UNIQUE INDEX ON tab(LOWER(col));
> or even by using UPPER:
> CREATE UNIQUE INDEX ON tab(UPPER(col));
or possibly:
CREATE UNIQUE INDEX ON tab((col::citext));
--
⚂⚃ 100% natural