> Just FYI, there's an index entry for BETWEEN in the PG docs too: > http://www.postgresql.org/docs/7.4/static/bookindex.html > although it seems to mistakenly be lowercase instead of uppercase > as one would expect.
I think I tried searching on 'between' but didn't find anything. > In general though I agree that the indexing of the docs is pretty > weak. Perhaps someone would care to step up and submit docs patches > to improve the situation? Adding index entries is no sweat if you > have even a moderate acquaintance with SGML or HTML ... we just need > someone willing to go through the files and add suitable entries ... I may look into it after the first of the year, though I'm likely to propose something more sweeping than that. -- Mike Nolan ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match