Re: Override PostgreSQL internal functions

Поиск
Список
Период
Сортировка
Искать
От
Vik Fearing
Тема
Re: Override PostgreSQL internal functions
Дата
Msg-id
530DC7F6.3000202@dalibo.com
Ответ на
Список
Дерево обсуждения
Override PostgreSQL internal functions Sameer Kumar <sameer.kumar@ashnik.com>
Re: Override PostgreSQL internal functions David Johnston <polobo@yahoo.com>
Re: Override PostgreSQL internal functions Sameer Kumar <sameer.kumar@ashnik.com>
Re: Override PostgreSQL internal functions Vik Fearing <vik.fearing@dalibo.com>
Re: Override PostgreSQL internal functions Sameer Kumar <sameer.kumar@ashnik.com>
Re: Override PostgreSQL internal functions Vik Fearing <vik.fearing@dalibo.com>
Re: Override PostgreSQL internal functions Simon Riggs <simon@2ndQuadrant.com>
Re: Override PostgreSQL internal functions Sameer Kumar <sameer.kumar@ashnik.com>
On 02/26/2014 10:36 AM, Sameer Kumar wrote:
Is there a way I can override (not overload) PostgreSQL internal functions e.g. replace()?

By default replace() will replace string based on case sensitivity. I want to override this behavior and make it case insensitive.

You would be much better off to use the citext extension and typing your columns appropriately.

http://www.postgresql.org/docs/current/static/citext.html
-- 
Vik
В списке pgsql-novice по дате отправления
От: Sameer Kumar
Дата:
От: samcoffey
Дата:
FAQ