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'
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
