From: Hale Pringle <halepringle@yahoo.com>
To: pgsql-jdbc@postgresql.org
Subject: Select * from users WHERE upper(lastName) = upper('Pringle')
Date: Fri, 10 Jan 2003 18:45:43 -0500
Message-ID: <HIEOJHJBFLIEMFCAOMOEIEMCCIAA.halepringle@yahoo.com> (raw)
In-Reply-To: <3E10825A.9000608@meinl.bnv-bamberg.de>
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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: halepringle@yahoo.com, pgsql-jdbc@postgresql.org
Subject: Re: Select * from users WHERE upper(lastName) = upper('Pringle')
In-Reply-To: <HIEOJHJBFLIEMFCAOMOEIEMCCIAA.halepringle@yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox