Re: Select * from users WHERE upper(lastName) = - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Select * from users WHERE upper(lastName) =
Date
Msg-id 1042331290.2327.6.camel@inspiron.cramers
Whole thread Raw
In response to Select * from users WHERE upper(lastName) = upper('Pringle')  ("Hale Pringle" <halepringle@yahoo.com>)
List pgsql-jdbc
What does select * from ... where trim(upper(lastname)) ==
upper('Pringle') return?

Dave
On Fri, 2003-01-10 at 18:45, Hale Pringle wrote:
> I have notices that when you want to use the upper() function, you must also
> use the trim().
>
> For example,
> In a situation where a column names lastname is char(40):
> SELECT * FROM users WHERE lastname = 'Pringle'   returns one row.
>
> SELECT * FROM users WHERE UPPER(lastname) = UPPER('Pringle')   will return
> zero rows.
>
> SELECT * FROM users WHERE TRIM(UPPER(lastname) = TRIM(UPPER('Pringle'))
> will return one row.
>
> This seems odd to me.  Can someone explain?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
--
Dave Cramer <Dave@micro-automation.net>


pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Sequence
Next
From: Eric Frazier
Date:
Subject: Re: persistent JDBC connections with a daemon