[LIH] psql , triggers and errors

[Binand Raj S.]

>>>>> "Penguin" == Penguin  <[EMAIL PROTECTED]> writes:

        IF NEW.salary ISNULL THEN
                RAISE EXCEPTION ''% cannot have NULL salary'', NEW.empname;
        END IF;

Ages since I worked with postgres, but...

needn't that be a numerical comparison? Your salary is an int4, not
text or varchar or whatever...

Binand


_______________________________________________
linux-india-help mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/linux-india-help