On Sat, Dec 15, 2018 at 12:14 AM Robert Haas <robertmh...@gmail.com> wrote: > > On Wed, Nov 28, 2018 at 1:43 PM Alvaro Herrera <alvhe...@2ndquadrant.com> > wrote: > > Right, I think option 4 is a clear improvement over option 1. I can get > > behind that one. Since not many people care to vote, I think this tips > > the scales enough to that side. > > I'm showing up very late to the party here, but I like option 1 best. > I feel like the SQL standard has a pretty clear idea that NULL is how > you represent a value is unknown, which shows up in a lot of places. > Deciding that we're going to use a different sentinel value in this > one case because NULL is a confusing concept in general seems pretty > strange to me. >
The proposed patch has used option-4. I am not sure if you are completely convinced or not, but I hope that you won't mind too much if we pursue with option-4. -- With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com