tacacs=> CREATE TABLE bugdb
tacacs-> (
tacacs-> id int4 default nextval('bugdb_id_seq') primary key,
tacacs-> email varchar(50) NOT NULL,
tacacs-> sdescr varchar(80),
tacacs-> ldescr text,
tacacs-> version char(16),
tacacs-> status char(16),
tacacs-> comments text,
tacacs-> ctime datetime,
tacacs-> mtime datetime
tacacs-> );
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index bugdb_pkey for
table bugdb
CREATE
tacacs=> insert into bugdb values ( 1,'daniele@orlandi.com','Test
BUG','TestText','3.0.0','open' );
INSERT 2725845 1
tacacs=> SELECT id,status,version,email,sdescr FROM bugdb WHERE status = 'open'
ORDER BY id;
id|status | version|email |sdescr
--+----------------+----------------+-------------------+--------
1|open |3.0.0 |daniele@orlandi.com|Test BUG
(1 row)
tacacs=> SELECT id,status,version,email,sdescr FROM bugdb WHERE lower(status) =
'open' ORDER BY id;
id|status|version|email|sdescr
--+------+-------+-----+------
(0 rows)
tacacs=> SELECT id,status,version,email,sdescr FROM bugdb WHERE lower(status) =
'open ' ORDER BY id;
id|status | version|email |sdescr
--+----------------+----------------+-------------------+--------
1|open |3.0.0 |daniele@orlandi.com|Test BUG
(1 row)
As you may see, LOWER(status) matches only 'open ', not 'open'.
Is it the correct behaviour of LOWER() when applied to fixed size fields ?
Regards.
--
Daniele
-------------------------------------------------------------------------------
"I'd crawl over an acre of 'Visual This++' and 'Integrated Development
That' to get to gcc, Emacs, and gdb. Thank you."
(By Vance Petree, Virginia Power)
-------------------------------------------------------------------------------
Se telecom italia aggiungesse uno scatto al giorno ad ogni abbonato, dal
primo Gennaio avrebbe rubato 668.954.000.000 Lire.
-------------------------------------------------------------------------------
Daniele Orlandi - Utility Line Italia - http://www.orlandi.com
Via Mezzera 29/A - 20030 - Seveso (MI) -