Tom Allison wrote: > >> In postgres, it's possible to create an index based on a function: >> >> CREATE INDEX lower_userid ON dbmail_users (lower(userid)); >> >> At that point the query would take about the same amount of time and >> userids can stay in different cases. > > > That is very cool and one more reason why I prefer postgres. > However, I didn't find that as an index in the table definition. > > Did I not see it because I didn't know what I was looking for, or is it > not exactly there?
It wasn't there. It is now (dbmail_2_2_branch). -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
