Luke Lonergan wrote:
Sure - it's here:
http://momjian.us/mhonarc/patches_hold/msg00381.html
To clarify - we've fixed this in Greenplum db - the patch as submitted
is (hopefully) a hint about how to fix it in Postgres, rather than a
working patch... as its full of non-postgres functions and macros:
CdbPathLocus_MakeHashed
cdbpathlocus_pull_above_projection
cdbpullup_findPathKeyItemInTargetList
cdbpullup_makeVar
cdbpullup_expr
Cheers
Mark
---------------------------(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
