Re: Matching against a field case in-sensitive.

From: Reid Thompson <reid(dot)thompson(at)ateb(dot)com>
To: James Dooley <jamdooley(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Matching against a field case in-sensitive.
Date: 2009-03-02 15:21:26
Message-ID: 49ABF976.5060204@ateb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

James Dooley wrote:
> Hi,
>
> Since PostgreSQL is by default case sensitive, I would like to know if
> it is possible to do a search or somehow set the column in a relation to
> be case insensitive (on search at least).
>
> I would however like to store it case sensitive so I can display it as
> it was stored.
>
> Ps. I am not interested in creating another column.
>
>
>
>

select value from table where relation ilike 'search-criteria'

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2009-03-02 15:25:27 Detemine database size on Postgres 8.0
Previous Message Martin Gainty 2009-03-02 15:18:06 Re: Matching against a field case in-sensitive.