Tom Lane wrote:

Andreas Pflug <[EMAIL PROTECTED]> writes:


- Implement a way to enable triggers to check which columns are affected by the triggering statement.



This can already be done by comparing old and new values, no?


No, this is not the case.

UPDATE foo SET x=x, y=y
is different from
UPDATE foo SET y=y
if triggers maintaining x are involved. I had this case, and had to do quite weird stuff to implement this.


Regards,
Andreas



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match

Reply via email to