3 ms·
It may be work sometime in the future, but having to prefix every query with a null check sounds bonkers. A view can be optimised to do all that for you. I made
by chewyfruitloop 4y ago
It may be work sometime in the future, but having to prefix every query with a null check sounds bonkers.
A view can be optimised to do all that for you.
I made the what the flip expression reading that they did a prefix on everything.
- Inviz 4y agoIt can be the other way around, that the table has prefix/suffix, and the view doesnt. Alternatively view can be created with the same name, but in a different schema, which is set with higher priority for the user (e.g. via search_path in PG)