News for hackers. Stuff that matters.

A comment on Amazon’s Consumer Business Turned Off Final Oracle Database. Parent comment

Re:Amazon’s Consumer Business Turned Off Final Oracle Database by fanf2 on Tuesday October 15, 2019 @04:37PM (#21263459)
Instead of a table-valued parameter, wouldn’t you use an array of a composite type in PostgreSQL? What are the relative good and bad points?
[ Parent | on HN ]
Re:Amazon’s Consumer Business Turned Off Final Oracle Database by philliphaydon on Wednesday October 16, 2019 @02:19AM (#21267590)
Yeah. And you don’t need to create a custom type to handle it as a parameter. So it’s easier.

The only thing SQLServer has over PostgreSQL is multiply resultsets. That’s it. I really wish that existed in PostgreSQL to prevent round trips.

[ Parent | on HN ]