Re: Case Insensitive

Поиск
Список
Период
Сортировка
От Tim Clarke
Тема Re: Case Insensitive
Дата
Msg-id 74504e0f-b223-891a-93fd-ec4eb155bdad@minerva.info
обсуждение исходный текст
Ответ на Re: Case Insensitive  (Andy Anderson <aanderson@amherst.edu>)
Список 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 по дате отправления:

Предыдущее
От: Andreas Kretschmer
Дата:
Сообщение: Re: Case Insensitive
Следующее
От: "Brad Nicholson"
Дата:
Сообщение: Re: Case Insensitive