| From: | Theerasak Maneeneim <theerasak(at)thns(dot)co(dot)th> | 
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org | 
| Subject: | String comparison problem. | 
| Date: | 2008-05-30 03:43:45 | 
| Message-ID: | 483F77F1.40101@thns.co.th | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-admin | 
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | kevin kempter | 2008-05-30 04:35:19 | postgres, syslog and freeBSD | 
| Previous Message | Medi Montaseri | 2008-05-29 05:14:12 | Re: what happend to my database |