Postgres Pro
Downloads
Home   >   mailing lists

Re: Override PostgreSQL internal functions - Mailing list pgsql-novice

From Vik Fearing
Subject Re: Override PostgreSQL internal functions
Date
Msg-id 530DC7F6.3000202@dalibo.com
Whole thread Raw
In response to Override PostgreSQL internal functions  (Sameer Kumar <sameer.kumar@ashnik.com>)
Responses Re: Override PostgreSQL internal functions
List pgsql-novice
Tree view
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 by date:

Previous
From: Sameer Kumar
Date:
Subject: Override PostgreSQL internal functions
Next
From: samcoffey
Date:
Subject: Re: Connection rejected: could not fork new process for connection: Unknown error