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

From Steve Brett
Subject Re: Problem with sql function LOWER
Date
Msg-id C05E7DA1218ED411BF8A00105AC95A8E05A1F2B9@sv-cntrmail.emis.local
Whole thread Raw
In response to Problem with sql function LOWER  ("Th Templ" <templ_th@hotmail.com>)
List pgsql-jdbc
SELECT Nom,Prenom from personne where
 LOWER(Nom)='test';

Steve

> -----Original Message-----
> From: Th Templ [mailto:templ_th@hotmail.com]
> Sent: 03 July 2002 14:50
> To: pgsql-jdbc@postgresql.org
> Subject: [JDBC] Problem with sql function LOWER
>
>
> 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
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
>
>



pgsql-jdbc by date:

Previous
From: "Th Templ"
Date:
Subject: Problem with sql function LOWER
Next
From: "Th Templ"
Date:
Subject: Re: Problem with sql function LOWER