From: | "Th Templ" <templ_th(at)hotmail(dot)com> |
---|---|
To: | SBrett(at)e-mis(dot)com |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Problem with sql function LOWER |
Date: | 2002-07-03 14:18:48 |
Message-ID: | F964AsK6ExU8raUMTzF00006c23@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
I make a mistake in my mail...
SELECT Nom,Prenom from personne where
LOWER(Nom)='test';
This request returns no row.
Templth
>From: Steve Brett <SBrett(at)e-mis(dot)com>
>To: Th Templ <templ_th(at)hotmail(dot)com>, pgsql-jdbc(at)postgresql(dot)org
>Subject: RE: [JDBC] Problem with sql function LOWER
>Date: Wed, 3 Jul 2002 15:12:52 +0100
>
>SELECT Nom,Prenom from personne where
> LOWER(Nom)='test';
>
>Steve
>
> > -----Original Message-----
> > From: Th Templ [mailto:templ_th(at)hotmail(dot)com]
> > Sent: 03 July 2002 14:50
> > To: pgsql-jdbc(at)postgresql(dot)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(at)postgresql(dot)org)
> >
> >
_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Brett | 2002-07-03 14:24:50 | Re: Problem with sql function LOWER |
Previous Message | Steve Brett | 2002-07-03 14:12:52 | Re: Problem with sql function LOWER |