Re:Easy, alternative soft deletion: `deleted_record_insert`
by chewyfruitloop on Sunday January 01, 2023 @07:19AM
(#34205740)
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.
[ Parent
| on HN ]
Re:Easy, alternative soft deletion: `deleted_record_insert`
by Inviz on Sunday January 01, 2023 @08:40AM
(#34206176)
It 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)