And is it possible to make a query containing an ORDER BY that is not case
sensitive ?
Thanks
Mari-Mai
-----Original Message-----
From: Peter Eisentraut [mailto:peter_e@gmx.net]
Sent: Friday, June 09, 2000 2:58 AM
To: HENAFF Mari-mai FTRD/DMI/LAN
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] accent marks
HENAFF Mari-mai FTRD/DMI/LAN writes:
> Is it possible to configure PostgreSQL, so that it is not accent mark
> sensitive when making conditions upon strings on the queries ?
No, you'll have to do that yourself. A simple tr 'âàáéÿ' 'aaaey' etc.
could possibly do on the client side.
--
Peter Eisentraut Sernanders väg 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden