citext – select * from depesz;

Waiting for 8.4 – case insensitive text ( citext )

On 29th of July, Tom Lane committed patch written by David E. Wheeler, which added new contrib module: citext.