4 ms·
Yep you can, though a lot of systems that should know better also assume they don't have side effects. For example postgrest GETs happen in readonly transaction
by giraffe_lady 5y ago
Yep you can, though a lot of systems that should know better also assume they don't have side effects. For example postgrest GETs happen in readonly transactions which would cause a problem if you wanted to use a system like this to keep an audit logs of hits to a certain endpoint or whatever.
I think you can use a standalone VALUES statement to avoid side effects? Those aren't well supported even though it's part of the SQL spec, but postgres does have them.