Rikard Pavelic <[email protected]> writes:
> It would be great if Postgres could rewrite this query
AFAICS those queries are not going to produce the same results,
so Postgres would be 100% incorrect to rewrite it like that for you.
(If they do produce the same results, it would depend on a bunch
of assumptions you have not stated.)
regards, tom lane
--
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance