On Wed, 2007-09-12 at 10:48 -0400, Tom Lane wrote: > Simon Riggs <[EMAIL PROTECTED]> writes: > > The following bug fix has not yet been applied to CVS > > http://archives.postgresql.org/pgsql-patches/2007-06/msg00100.php > > Frankly, this looks much more like it creates a bug than fixes one. > I have not looked at all of the original thread, but this adds a wart > (two warts, really) that seems certain to do the wrong thing in cases > other than the one you are thinking of.
Well, that's not a great help for anybody. What next action do you propose? -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com ---------------------------(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