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