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
--
Ilja Booij
IC&S B.V.
Stadhouderslaan 57
3583 JD Utrecht
www.ic-s.nl
T algemeen: 030 6355730
T direct: 030 6355739
F: 030 6355731
E: [EMAIL PROTECTED]