Home > mailing lists

Creating an index on PostgreSQL 7.4.3 - Mailing list pgsql-general

From	Ardian Xharra (Boxxo)
Subject	Creating an index on PostgreSQL 7.4.3
Date	April 5, 2006 18:01:26
Msg-id	021001c658da$b97b7af0$6a01a8c0@BOXXO.ARDIAN Whole thread Raw
Responses	Re: Creating an index on PostgreSQL 7.4.3 (Martijn van Oosterhout <kleptog@svana.org>)
List	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!

From: Bruno Wolff III
Date: 05 April 2006, 17:26:50
Subject: Re: PostgreSQL x Sybase

From: "Ets ROLLAND"
Date: 05 April 2006, 18:01:33
Subject: Couldn't create a database in PG 8.1.3 win32