Re: Matching against a field case in-sensitive. - Mailing list pgsql-general

In response to James Dooley :
> 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.

test=# select * from foo where t = 'foo';
 i |  t
---+-----
 1 | foo
(1 row)

test=*# select * from foo where lower(t) = lower('foo');
 i |  t
---+-----
 1 | foo
 2 | FOO
(2 rows)


You can also create an index based on lower() for such queries.


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net