Hacker News new | past | comments | ask | show | jobs | submit login

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.



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)




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: