From: Tim Clarke <tim.clarke@minerva.info>
To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Case Insensitive
Date: Thu, 28 Mar 2019 12:09:25 +0000
Message-ID: <74504e0f-b223-891a-93fd-ec4eb155bdad@minerva.info> (raw)
In-Reply-To: <7EF19AD1-94E8-4F8A-88E8-2F21B564AE2C@amherst.edu>
References: <CAGuFTBU1fACZWYdVwU-HiBJWAt2QFRa9fkB+SovmVMoUjVbekw@mail.gmail.com>
<CADp-Sm4RWjbFQix1_XH7hstj6FY-EZj-f2veSgR_Z7Ut=tdDEA@mail.gmail.com>
<CA+weYr33E8EuntzGdwApB2Qgrj+EZ_djtv-r0wn06yYDuLGfrQ@mail.gmail.com>
<7EF19AD1-94E8-4F8A-88E8-2F21B564AE2C@amherst.edu>
On 28/03/2019 11:10, Andy Anderson wrote:
Would this also select characters with diacritical marks? For example,
eid | ename
-----+-------
1 | aaa
2 | AAA
3 | áäâ
4 | āåȧ
— Andy
For that you need https://www.postgresql.org/docs/10/unaccent.html
Tim Clarke
Main: +44 (0)1376 503500 | Fax: +44 (0)1376 503550
Web: https://www.manifest.co.uk/
Minerva Analytics Ltd
9 Freebournes Court | Newland Street | Witham | Essex | CM8 2BL | England
----------------------------------------------------------------------------------------------------------------------------
Copyright: This e-mail may contain confidential or legally privileged information. If you are not the named addressee you must not use or disclose such information, instead please report it to admin@minerva.info<mailto:admin@minerva.info>
Legal: Minerva Analytics is the trading name of: Minerva Analytics
Ltd: Registered in England Number 11260966 & The Manifest Voting Agency Ltd: Registered in England Number 2920820 Registered Office at above address. Please Click Here >><https://www.manifest.co.uk/legal/; for further information.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tim.clarke@minerva.info, pgsql-general@lists.postgresql.org
Subject: Re: Case Insensitive
In-Reply-To: <74504e0f-b223-891a-93fd-ec4eb155bdad@minerva.info>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox