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'