On 20th of November Tom Lane committed patch by Takahiro Itagaki which adds interesting functionality: Add a WHEN clause to CREATE TRIGGER, allowing a boolean expression to be checked to determine whether the trigger should be fired. For BEFORE triggers this is ...

June 18th, 2008 by depesz | Tags: , , , , , | 7 comments »

Every now and then I see people ask the question - how to create table if it doesn't exist yet, how to drop it, but only if it does exist and so on. Well, starting from 8.2 dropping should be not ...