Matthew T. O'Connor wrote: >> I'll changing the unique key on headername to a unique key on >> lower(headername) > > OK, I thought about that, but I wasn't sure if it was legal, glad to > hear it is.
No no, don't just take my word for it. I'm not a postgres expert at all. But at least for postgres-8.1 this works. I have *not* tested on any other versions. Could someone please confirm this sql snippet on pg-7 please? create table testtable (id varchar(100) default '' not null); create index testtable_1 on testtable(lower(id)); -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
