Skip site navigation (1) Skip section navigation (2)

Bug #615: Bug in ilke and ~~* Sql expression

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #615: Bug in ilke and ~~* Sql expression
Date: 2002-03-14 16:22:10
Message-ID: 20020314162210.4BA4F475E94@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Torsten Krmer (tk(at)kreakom(dot)de) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
Bug in ilke and ~~* Sql expression

Long Description
i tried to do a select on some columns case insensitive.
some charachters like .. the ilike,~~*,upper made mistakes

Sample Code
select upper('GaStstttEn');
    upper
-------------
 GASTSTTTEN
(1 row)

select upper('GaStstttEn');
    upper
-------------
 GASTSTTTEN
(1 row)


select data_content from feature where data_content ~~* 'GaStstttEn';
=>
 data_content
--------------
 Gaststtten
(1 row)


select data_content from feature where data_content ~~* 'GaStstttEn';
=>
 data_content
--------------
(0 rows)

select data_content from feature where upper(data_content)=upper('GaStstttEn');
=>
 data_content
--------------
 Gaststtten
(1 row)

select data_content from feature where upper(data_content)=upper('GaStstttEn');
=>
 data_content
--------------
(0 rows)




No file was uploaded with this report


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-03-14 17:27:23
Subject: Re: Bug #613: Sequence values fall back to previously chec
Previous:From: Stephan SzaboDate: 2002-03-14 15:33:41
Subject: Re: problem with new postgresql driver

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group