New Features Coming in PostgreSQL 10

Re:New Features Coming in PostgreSQL 10 by smac8 on Saturday April 08, 2017 @01:08PM (#14067872)

Wow, so awesome. I do hope at some point we can see some language improvements to PLPGSQL. More basic data structures could go a long way in making that language really useful, and I still consider views/stored procedures a superior paradigm to client side sql logic

[ Parent | on HN ]

Re:New Features Coming in PostgreSQL 10 by rhaas on Saturday April 08, 2017 @01:14PM (#14067894)

I agree with you that stored procedures are superior to client-side logic, because it means that you can have multiple routes of access to the database and all of them enforce the same business logic. But what exactly do you mean by "more basic data structures"?

[ Parent | on HN ]

Re:New Features Coming in PostgreSQL 10 by pgaddict on Saturday April 08, 2017 @05:29PM (#14069143)

PL/SQL has various types of collections, for example, that are super-useful when you need to do more complicated processing without having to create temporary tables and such.

[ Parent | on HN ]