Ludwig Lim <[EMAIL PROTECTED]> wrote: > I am just wondering. Which one is executed first: > CHECK Constraints or BEFORE INSERT OR UPDATE TRIGGER?
First the BEFORE... TRIGGERs, then the CHECK contraints, so you definetly can change a row in a trigger to match the contraints... Regards, Michael Paesold ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org