Re: [BUGS] BUG #2006: queryoptimizer and comparing a primary key

2005-10-28 Thread Richard Huxton
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

Re: [BUGS] BUG #2006: queryoptimizer and comparing a primary key of biginteger and a literal

2005-10-28 Thread Tom Lane
"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;

[BUGS] BUG #2006: queryoptimizer and comparing a primary key of biginteger and a literal

2005-10-28 Thread Atanas Hristov
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