Re: Case Insensitive - Mailing list pgsql-general

From Tim Clarke
Subject Re: Case Insensitive
Date
Msg-id 74504e0f-b223-891a-93fd-ec4eb155bdad@minerva.info
Whole thread Raw
In response to Re: Case Insensitive  (Andy Anderson <aanderson@amherst.edu>)
List pgsql-general
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
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 >> for further information.

pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Case Insensitive
Next
From: "Brad Nicholson"
Date:
Subject: Re: Case Insensitive