Creating an index on PostgreSQL 7.4.3

From: "Ardian Xharra (Boxxo)" <axharra(at)boxxo(dot)info>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Creating an index on PostgreSQL 7.4.3
Date: 2006-04-05 17:59:46
Message-ID: 021001c658da$b97b7af0$6a01a8c0@BOXXO.ARDIAN
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Thanks!

Attachment Content-Type Size
unknown_filename text/plain 144 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ets ROLLAND 2006-04-05 18:01:27 Couldn't create a database in PG 8.1.3 win32
Previous Message Bruno Wolff III 2006-04-05 17:28:16 Re: PostgreSQL x Sybase