weird lower() problem with character

Поиск
Список
Период
Сортировка
От Björn Metzdorf
Тема weird lower() problem with character
Дата
Msg-id 001a01c2c3d9$8698de00$81c206d4@office.turtleentertainment.de
обсуждение исходный текст
Ответы Re: weird lower() problem with character  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi,

it seems that something has changed in handling 'character' datatypes.

With 7.2.3 this worked fine, with 7.3.1 it does not work.

This is a test with varchar, and it works:
==============================================================
test=> create table test ( test varchar(200) );
CREATE TABLE
test=> insert into test values ('test@test.com');
INSERT 12016215 1
test=> select * from test where test = lower('TEST@TEST.COM');
     test
---------------
 test@test.com
(1 row)
==============================================================

with 'character' it does not work anymore:
==============================================================
test=> create table test ( test character(200) );
CREATE TABLE
test=> insert into test values ('test@test.com');
INSERT 12016228 1
test=> select * from test where test = lower('TEST@TEST.COM');
 test
------
(0 rows)
==============================================================

Comments? How can I fix that without converting to varchar?

Regards,
Bjoern


В списке pgsql-general по дате отправления:

Предыдущее
От: "frank_lupo"
Дата:
Сообщение: drop table problem
Следующее
От: Dennis Gearon
Дата:
Сообщение: Re: More PHP DB abstraction layer stuff