BUG #7783: lower & upper function incorrect work

From: alex(dot)shniperson(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7783: lower & upper function incorrect work
Date: 2013-01-03 09:07:49
Message-ID: E1TqgmD-0007Fs-JZ@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 7783
Logged by: Alexander Shniperson
Email address: alex(dot)shniperson(at)gmail(dot)com
PostgreSQL version: 9.1.7
Operating system: osx lion 10.7.5
Description:

Hi.

I have problem at my project, try to do simple steps:
1) create DataBase with
ENCODING = 'UTF8'
LC_COLLATE = 'C'
LC_CTYPE = 'C'

2) create new table at just created database

CREATE TABLE testtable
(
id serial NOT NULL,
name character varying(50) NOT NULL,
CONSTRAINT testtable_pkey PRIMARY KEY (id )
)

3) insert one simple record with Russian word

INSERT INTO testtable (id, name) VALUES (1, 'Залог');

4) try to select data with upper & lower functions with 'like' operator

select *, lower(name), upper(name) from testtable where lower(name) like
'%залог%'

5) as result you must see nothing, just fields without data

fix it please, thanks.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message smatiz 2013-01-03 18:20:10 BUG #7784: trouble with pl ERROR: missing FROM-clause entry for table
Previous Message alex.shniperson 2013-01-03 08:44:17 BUG #7781: pgagent incorrect installation