News for hackers. Stuff that matters.
Re:At 22 years old, Postgres might just be the most advanced... by BrentOzar on Wednesday December 05, 2018 @03:11PM (#18611981)
> It still doesn't have proper upsert or JSON columns

Upsert (MERGE) was added in SQL Server 2008 (although it's chock full of known bugs): https://www.mssqltips.com/sqlservertip/3074/use-caution-with...

JSON was added in SQL Server 2016, although indexing it is still tricky: https://docs.microsoft.com/en-us/sql/relational-databases/js...

Re:At 22 years old, Postgres might just be the most advanced... by manigandham on Wednesday December 05, 2018 @03:13PM (#18611998)
That's what I meant by "proper". It can do it, but PG does it better. It's one area that I wish they would invest time into considering the large developer impact it would have.
Re:At 22 years old, Postgres might just be the most advanced... by SigmundA on Wednesday December 05, 2018 @05:54PM (#18613570)
My understanding is they got burned by all the work put into the XML datatype and don't want to repeat it with JSON, hence the more conservative approach.