From: | Jean-Luc Lachance <jllachan(at)nsd(dot)ca> |
---|---|
To: | Th Templ <templ_th(at)hotmail(dot)com> |
Cc: | SBrett(at)e-mis(dot)com, pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Problem with sql function LOWER |
Date: | 2002-07-03 15:05:46 |
Message-ID: | 3D2312CA.1644627F@nsd.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Is Nom of type varchar or char?....
If char:
SELECT Nom,Prenom from personne where trim(lower(Nom))='test';
Th Templ wrote:
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-07-03 15:56:46 | Re: Problem with sql function LOWER |
Previous Message | Steve Brett | 2002-07-03 14:24:50 | Re: Problem with sql function LOWER |