Peter Breton <[EMAIL PROTECTED]> writes:
> Is there something that I'm not understanding here, or is this a bug?
What locale are you using? Non-C locales have sorting rules more
complex than you seem to be expecting.
$ cat data
e
,
ke
k,
ken
k,
kens
k, P
ens
, P
$ LANG=C sort data
,
, P
e
ens
k
Hi,
On my Postgres system ( PostgreSQL 7.1.2 on i686-pc-linux-gnu, compiled
by GCC 2.96), I get the following odd behavior in string compares:
# Works -- e (ASCII code 101) is after comma (ASCII code 44)
select current_time where 'e' > ',';
# Works -- adding a k to the front of both strings
se
