Hi, I was playing around with some sql in postgres and got to wondering why the optimiser can't figure out that rearranging some expressions can result in massive improvements in the queue plan. For example id + 5 < 100 compared with id < 100 - 5. Is it simply that no one has go around to doing it or is there some deeper reasons? It's not really important I'm just curious. Cheers, -- Michael Graham <mgraham@xxxxxxxxx> -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
