Could someone first please confirm that left joins are really this broken in
postgres. Perhaps it's something in Sergey's setup/build of postgres.
Left joins are *so* much more readable than normal joins.
Ilja Booij wrote:
Sergey Spiridonov wrote:
Seems to be postgresql problem. This query is used in 3 places:
2 times in dbmsgbuf.c and 1 time in dbsearch.c. I changed them and
till now everything works fine...
# postgres --version
postgres (PostgreSQL) 7.3.6
This query is a good candidate for being replaced then. Strange that
PostgreSQL's query planner doesn't do this right...
Since the query will also work in MySQL I'll change it (unless anybody
has any good reason for not doing it.)
Ilja
--
________________________________________________________________
Paul Stevens [EMAIL PROTECTED]
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands_______________________________________www.nfg.nl
