Re: Problem with sql function LOWER - Mailing list pgsql-jdbc

"Th Templ" <templ_th@hotmail.com> writes:
> SELECT Nom,Prenom from personne where
> LOWER(Nom)='test';

I'm guessing that Nom is of type char(N) and therefore has padding
spaces in it.  You should use varchar or text instead of char to
avoid this sort of difficulty.

            regards, tom lane