News for hackers. Stuff that matters.
Re:For Want of a JOIN by jasonhansel on Thursday December 22, 2022 @01:52PM (#34096934)
Those languages all have first-class functions and OOP-style encapsulation.

In SQL stored procedures (at least in Postgres), you can't have a variable that holds multiple records. You can't even define a variable inside of a block.

Re:For Want of a JOIN by ttfkam on Thursday December 22, 2022 @09:44PM (#34101791)
DECLARE foo record[];
Re:For Want of a JOIN by nhinck2 on Friday December 23, 2022 @12:14AM (#34102540)
Temp tables?