Re: [BUGS] BUG #6723: Exception for correct query

2012-07-09 Thread Tom Lane
heiko.helmbre...@xclinical.com writes: > The optimizer is using a where condition for a full table, not to the > results of a join/subselect result, that's why it is tried to use casts, > that cannot work on the whole table, here are the easy steps to reproduce > the problems: This is not a bug.

[BUGS] BUG #6723: Exception for correct query

2012-07-09 Thread heiko . helmbrecht
The following bug has been logged on the website: Bug reference: 6723 Logged by: Heiko Helmbrecht Email address: heiko.helmbre...@xclinical.com PostgreSQL version: 8.4.12 Operating system: Linux Description: The optimizer is using a where condition for a full table, n