Re: Matching against a field case in-sensitive.

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