On 07/12/17 15:32, Joshua D. Drake wrote: > On 12/07/2017 05:30 AM, Peter Eisentraut wrote: >> >>> How does that work? Is it using one of the hidden columns on a row? >> It means that for example if an update record is produced, the entire >> row is included in the record as the key. > > Thanks Peter, Craig also responded, > > The confusion I have is what if we have two rows that are identical and > now that I think about it we would just update both rows, yes? That > would make sense because it would produce two updated rows. >
No it won't, it will update only one row, it does not try to find multiple matching rows. -- Petr Jelinek http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
