Re:Ask HN: Have you ever used PL/pgSQL – the PostgreSQL prog...
by Something1234 on Sunday September 02, 2018 @08:31PM
(#17899440)
PL/pgSQL supports entities? This is kind of amazing. Do you have a resource to pick this skill up?
[ Parent
| on HN ]
Re:Ask HN: Have you ever used PL/pgSQL – the PostgreSQL prog...
by dizzystar on Sunday September 02, 2018 @08:48PM
(#17899494)
I guess I should be more specific by what I mean by entities. I probably used the wrong word here:
https://www.postgresql.org/docs/10/static/plpgsql-statements...
PL/pgSQL gives you %I and %L, which allows you to specify table and column names. Basically, if you want to `select * from %I`, you have the option to call the specific table.
Re:Ask HN: Have you ever used PL/pgSQL – the PostgreSQL prog...
by Something1234 on Monday September 03, 2018 @11:06PM
(#17906318)
So what's the best way to leverage this feature in crud applications?