ekekakos <ekekakos(at)hol(dot)gr> writes:> And it does not work during the update.
Oh, you mean you want the field to change during updates? No, aDEFAULT won't do that for you. You'll have to use a trigger.
regards, tom lane