Re: 8.1 Unique Index Issue/Bug???

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Am Donnerstag, 13. Juli 2006 16:40 schrieb Chris Hoover:
> On this table, I have created a unique index on payer_trn03, payer_trn04,
> and expire_timestamp.  However, since the expire_timestamp is normally
> null, the unique index does not appear to be working.  I have been able to
> enter two identical rows into this table.

This behavior is correct according to the SQL standard, as two null values are 
not considered equal.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux