Atanas Hristov wrote:
Bug reference: 2006
Logged by: Atanas Hristov
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1 Beta 3
Operating system: FreeBSD 5
Description:queryoptimizer and comparing a primary key of biginteger
and a literal
Details:
foo=# CREATE
"Atanas Hristov" <[EMAIL PROTECTED]> writes:
> foo=# EXPLAIN ANALYZE SELECT 'foo' FROM foo WHERE id = 0; -- WHY POSTGRES
> DOES NOT IMPLICITLY DO CASTING OF THE LITERAL "0" ??
It works for me:
regression=# EXPLAIN ANALYZE SELECT 'foo' FROM foo WHERE id = 0;
The following bug has been logged online:
Bug reference: 2006
Logged by: Atanas Hristov
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1 Beta 3
Operating system: FreeBSD 5
Description:queryoptimizer and comparing a primary key of biginteger
and a literal
Detai