[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-admin
Subject: [ADMIN] String comparison problem.
From: Theerasak Maneeneim <theerasak () thns ! co ! th>
Date: 2008-05-30 3:43:45
Message-ID: 483F77F1.40101 () thns ! co ! th
[Download RAW message or body]
Dear All,
I have some problem with string comparison. I use
postgresql 8.3.1,UTF8 encoding, on CentOS 5.5. Why dose the result of
SQL statement : "select '1.1' < '101';" is false but "select
'1.1'::bytea < '101'::bytea;" is ture?
mis=# select '.' < '0';
?column?
----------
t
(1 row)
mis=# select '1.' < '10';
?column?
----------
t
(1 row)
mis=# select '1.1' < '101';
?column?
----------
f
(1 row)
mis=# select '1.1'::text < '101'::text;
?column?
----------
f
(1 row)
mis=# select '1.1'::bytea < '101'::bytea;
?column?
----------
t
(1 row)
Thank you very much.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic