On Sun, Jan 23, 2005 at 10:23:50 +0100, Ralph van Etten <ralph(at)et10(dot)org> wrote: > But I think there are situations where a serial isn't convenient > Like when you want an primary key which consists of the current > year and an sequence number. Like ('05', 1), ('05', 2), ('05', 3) etc. > With a sequence you must write extra code to reset the sequence every year > and you get into trouble if someone inserts data from the previous year... > A 'MAX(id)+1' is much simpler and cleaner then.
You don't normally want to do that either. You should use one sequence for all of the years.