case and accent insensitive

From: MOISES ESPINOSA <moikmeg(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: case and accent insensitive
Date: 2018-03-23 22:04:41
Message-ID: CAJW3KKZxhgB_F8R8ED63LDnp8QwBZTvR1cfvFag7VtpduK_qCQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2018-03-23 22:22:58 Re: FDW Foreign Table Access: strange LOG message
Previous Message legrand legrand 2018-03-23 21:30:48 pg_stat_statements: password in command is not obfuscated