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