On Wed, Apr 05, 2006 at 01:59:46PM -0400, Ardian Xharra (Boxxo) wrote: > Hello, > I have a client who is still using the version 7.4.3 > and creating an index like this doesn't work: > CREATE INDEX client__ascname__idx ON client (TO_ASCII(lower(name),'LATIN > 1')); > Does exists another way of creating an index in varchar who take on > consideration also the accents
I think expression indexes need another level of parenthesis, so maybe: CREATE INDEX client__ascname__idx ON client ((TO_ASCII(lower(name),'LATIN 1'))); Have a nice day, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them.
signature.asc
Description: Digital signature
