Problem with sql function LOWER - Mailing list pgsql-jdbc

From Th Templ
Subject Problem with sql function LOWER
Date
Msg-id F170q0XVy6REY3U8xT600006a26@hotmail.com
Whole thread Raw
List pgsql-jdbc
Hello,

I try to make this sql request but it returns nothing...

Tables personne
Nom       | Prenom
----------|------------
Test      | Test1

SELECT Nom,Prenom from personne where LOWER(personne.personne_nom)='test';

(0 row)

Is this syntax not correct?
Thanks for your help.
Templth

_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com




pgsql-jdbc by date:

Previous
From: tony
Date:
Subject: Re: Problem with accentuated characters
Next
From: Steve Brett
Date:
Subject: Re: Problem with sql function LOWER