Re: Override PostgreSQL internal functions

From: Vik Fearing <vik(dot)fearing(at)dalibo(dot)com>
To: Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Override PostgreSQL internal functions
Date: 2014-02-26 10:54:46
Message-ID: 530DC7F6.3000202@dalibo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message samcoffey 2014-02-26 10:59:00 Re: Connection rejected: could not fork new process for connection: Unknown error
Previous Message Sameer Kumar 2014-02-26 09:36:06 Override PostgreSQL internal functions