4 ms·
the downside with views it's that they are persistent so you can't reuse it only in the context of one connection you can use CTEs but only with one query
by cerved 5y ago
the downside with views it's that they are persistent so you can't reuse it only in the context of one connection
you can use CTEs but only with one query
- zimpenfish 5y ago> persistent so you can't reuse it only in the context of one connection Don't e.g. Postgres temporary views cover this case? "Temporary views are automatically dropped at the end of the current session."
- cerved 5y ago¯\_(ツ)_/¯ I expect vendor specific stuff called something along the lines of temporary view would do this, yes