Postgres Pro
Downloads
Home   >   mailing lists

case and accent insensitive - Mailing list pgsql-general

From MOISES ESPINOSA
Subject case and accent insensitive
Date
Msg-id CAJW3KKZxhgB_F8R8ED63LDnp8QwBZTvR1cfvFag7VtpduK_qCQ@mail.gmail.com
Whole thread Raw
Responses Re: case and accent insensitive  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List pgsql-general
Tree view
Hi,

I need to reproduced the following Oracle functionality in PostgreSQL:

CREATE INDEX index_ciudad ON world.ciudad ((NLSSORT(NOMBRE29,'nls_sort=''GENERIC_BASELETTER''')));

I don't know how i could reproduced case insensitive and accent insensitive.

Is there any collate?

Thanks.

pgsql-general by date:

Previous
From: legrand legrand
Date:
Subject: pg_stat_statements: password in command is not obfuscated
Next
From: Tom Lane
Date:
Subject: Re: FDW Foreign Table Access: strange LOG message