Rikard Pavelic <rikard.pavelic@zg.htnet.hr> 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