Re: select fails on indexed varchars.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alex Krohn <alex(at)gossamer-threads(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: select fails on indexed varchars.
Date: 2001-01-30 01:44:49
Message-ID: 26252.980819089@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> links=# select * from foo where a < 'Test0'::bpchar;
> a
> ---
> (0 rows)

> links=#

> Are you saying the second test should have returned true under C locale?

Yes. You are not really in C locale, or at least your postmaster isn't.
This looks like ISO sorting rules to me --- perhaps you are in en_US
locale.

> Is this a version dependant bug? Will downgrading to 6.x get me going?

No. Fix your locale. I'm afraid I don't have any more advice to offer
on that than I gave already ...

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Myron Scott 2001-01-30 09:25:19 PROC struct
Previous Message Alex Krohn 2001-01-29 23:13:41 Re: select fails on indexed varchars.