3 ms·
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 langua
by smac8 9y ago
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
- rhaas 9y agoI 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"?
- pgaddict 9y agoPL/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.