I wrote: > "Massimo Fidanza" <[EMAIL PROTECTED]> writes: >> this query is not correct and doesn't work with postgresql 8.1.
> It still works, if you enable add_missing_from. I take that back --- FROM is not the issue (indeed, it has one). The problem is the ORDER BY and LIMIT clauses. I dunno who put in this example, but I'd like some of what they were smoking. I've taken it out again, since without that it's not really showing anything that the prior examples don't cover. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings