Ged wrote:
Ty for those comments.
Hmm, I did try it out before posting of course, and I've just tried it
again to make sure I hadn't boobed with a typo. It seems my ISP is
running 8.0.8 and it's definitely not working on that. It *is* in the
8.0.13 documentation also though... So now I'm off to beg them to
upgrade.
Hmm - should work in any 8.0.x, the development team don't add new
features in point releases. I'm not sure if this feature wasn't there in
7.4 too.
Might be a bug affecting you though - could be worth checking the
release-notes in the back of the manual.
--
Richard Huxton
Archonet Ltd
---------------------------(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
