From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | lists(at)lists(dot)grot(dot)org |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: case insensitive unique index (part 2) |
Date: | 2001-02-09 03:59:22 |
Message-ID: | 17155.981691162@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
lists <lists(at)lists(dot)grot(dot)org> writes:
> mydb=> create unique index forward_rr on forward (lower(name));
> ERROR: DefineIndex: function 'lower(varchar)' does not exist
If you change the name column to type 'text' it will work. Or you
can make an extra pg_proc entry that relabels lower(text) as
lower(varchar) --- that's safe because text and varchar have the
same representation. I'm too lazy to reconstruct the necessary
command right now, but this has been described in the mail lists before.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Anthony E . Greene | 2001-02-09 05:40:36 | Re: Database and table name case sensitivity |
Previous Message | lists | 2001-02-09 03:39:28 | case insensitive unique index (part 2) |
From | Date | Subject | |
---|---|---|---|
Next Message | Ian Lance Taylor | 2001-02-09 04:08:39 | Re: Syslog and pg_options (for RPMs) |
Previous Message | Dominic J. Eidson | 2001-02-09 03:58:45 | Re: Syslog and pg_options (for RPMs) |