[fanf2]

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?

[philliphaydon]

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.