Neil Saunders <n.j.saunders@gmail.com> writes:
> I've tried to write something along the lines of the following:
> sdate = (NEW.start_date IS NOT NULL) ? NEW.start_date : OLD.start_date;
> edate = (NEW.end_date IS NOT NULL) ? NEW.end_date : OLD.end_date;
> But conditional assignment doesn't seem to be catered for.
The equivalent construct in SQL is CASE.
regards, tom lane