undreds
(if not thousands SQL) to use BETWEEN/AND instead. Any
suggestion?
-Original Message-
From: Dave Page [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 22, 2005 12:19 AM
To: Richard Huxton
Cc: Tom Yeh; pgsql-bugs@postgresql.org
Subject: RE: [BUGS] BUG #1487: Index problem
Tom M. Yeh wrote:
Yes, it really depends on Locale. If I created a
database with Locale = C, the problem won't happen (at
least so far). BTW, I forgot to mention I tested with
some Chinese and Japanese characters.
However, it raises another issue why a wrong Locale
would damage index? It shall only
> -Original Message-
> From: Richard Huxton [mailto:[EMAIL PROTECTED]
> Sent: 21 February 2005 16:13
> To: Dave Page
> Cc: Tom Yeh; pgsql-bugs@postgresql.org
> Subject: Re: [BUGS] BUG #1487: Index problem
>
> > pgAdmin uses libpq, just as psql does, s
Dave Page wrote:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Richard Huxton
Sent: 21 February 2005 15:37
To: Tom Yeh
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #1487: Index problem
The above can be replicated by using pgAdmin III only
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Richard Huxton
> Sent: 21 February 2005 15:37
> To: Tom Yeh
> Cc: pgsql-bugs@postgresql.org
> Subject: Re: [BUGS] BUG #1487: Index problem
>
> > The above can be r
Tom Yeh wrote:
I created an index for a table, say Entity, on a field, say id.
Then, the follwoing two SQL has different result:
select * from "Entity" e where e.id = '1000'
select * from "Entity" e where e.id like '1000'
What is the definition of "Entity"?
How many rows are there in the table?
Ho
The following bug has been logged online:
Bug reference: 1487
Logged by: Tom Yeh
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.1
Operating system: Windows XP
Description:Index problem
Details:
I created an index for a table, say Entity, on a field, say id
