Select * from users WHERE upper(lastName) = upper('Pringle')
| От | Hale Pringle |
|---|---|
| Тема | Select * from users WHERE upper(lastName) = upper('Pringle') |
| Дата | |
| Msg-id | HIEOJHJBFLIEMFCAOMOEIEMCCIAA.halepringle@yahoo.com обсуждение исходный текст |
| Ответ на | Re: batch example (Thorsten Meinl <Thorsten@meinl.bnv-bamberg.de>) |
| Ответы |
Re: Select * from users WHERE upper(lastName) =
Re: Select * from users WHERE upper(lastName) = upper('Pringle') Re: Select * from users WHERE upper(lastName) = upper('Pringle') |
| Список | pgsql-jdbc |
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?
В списке pgsql-jdbc по дате отправления: