"Nicholas" <[EMAIL PROTECTED]> writes: > Description: Variables selected in VIEWs under different names break > queries using those views
This is a poor description, the problem actually seems to be related to using sub-SELECTs in bitmap index scan conditions. Patch is here if you need it before 8.1.3 comes out: http://archives.postgresql.org/pgsql-committers/2006-01/msg00382.php regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match