2009/1/19 Scott Marlowe <scott.marlowe@xxxxxxxxx>: > Submit a patch. :) > > But seriously, it's doing what you told it to do. There might be > corner cases where you need a trigger to fire for a row on change, and > short-circuiting could cause things to fail in unexpected ways. as far as my little knowledge about pg goes, that would be just another addition to planner. <daydreaming> Say - when there's more than X % of value Y, and we do set column X to Y, it could add that 'where'. But what if we have more WHERE statements, and they are quite contradictory, etc, etc. It could actually do more damage than good. (yes, I do have quite few more 'against' than for)</daydreaming> I wrote that previous email, while waiting for breakfast, so I guess it wasn't the best idea in the world ;) -- GJ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
