Vadim Mikheev <vadim(at)krs(dot)ru> writes:
> Tom Lane wrote:
>> No, I think it should *only* substitute for NULL. Why assume
>> zero is special?
> As I remember this is how SERIAL works in Informix.
Ah. OK, if that's what they do then I agree we ought to act the same.
>> Another question is whether a SERIAL field should automatically be
>> UNIQUE (ie, create a unique index on it to prevent mistakes in manual
>> insertion of values for the field).
> Once again - I would like to see SERIAL compatible with
> SERIAL/IDENTY in other RDBMSes.
Yes, and? What do the other ones do?
regards, tom lane