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