On Wed, 2005-05-25 at 13:09 +0200, Sebastian Böck wrote: > Dawid Kuroczko wrote: > > > > > Be wary of the NULL values though. :) Either don't use them, add > > something like 'AND (text1 <> NEW.text1 OR text1 IS NULL OR NEW.text1 > > IS NULL)' or something more complicated. :) > > Thanks for the notice, but I have a special operator for this: > > CREATE OR REPLACE FUNCTION different (ANYELEMENT, ANYELEMENT) RETURNS and then there is the 'IS DISTINCT FROM' construct http://www.postgresql.org/docs/8.0/static/functions-comparison.html#AEN6094 gnari ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
