I've tried to write audit trigger which fires only when data changed, so I used "WHEN (OLD.* IS DISTINCT FROM NEW.*)" clause as described in documentation <http://www.postgresql.org/docs/9.4/static/sql-createtrigger.html> . Should this clause be independent from data type? because an error occurs when I'm trying to modify row with point data type: ERROR: could not identify an equality operator for type point
I guess it is dependent on data type as it requires an equality operator, and type "point" doesn't have one.
If it calling it a bug gets it changed I'm game...but IS DISTINCT FROM apparently looks for an equality operator and then performs negation instead of looking for a "non-equality" operator. Since the latter doesn't really even make sense (TBH it's probably syntatic sugar transformed by the parser) I don't blame it.