Re: Case Insensitive Data Type - Mailing list pgsql-general

From Tom Lane
Subject Re: Case Insensitive Data Type
Date
Msg-id 20954.1022271400@sss.pgh.pa.us
Whole thread Raw
In response to Re: Case Insensitive Data Type  (Neil Conway <nconway@klamath.dyndns.org>)
List pgsql-general
Neil Conway <nconway@klamath.dyndns.org> writes:
> You could have it run the SELECT on a view, where the relevant
> column is defined using lower() on the appropriate column
> of the real table.

But that only gets him halfway there.  He really wants the system to
do a lower() on the provided comparison constant, too.  I haven't
thought of a way to get the rule system to insert that.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Page viewer software?
Next
From: Tom Lane
Date:
Subject: Re: problem with my function