If you have specific columns that you frequently want to ignore (which, I think,... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		bobbyi on Dec 30, 2021 \| parent \| context \| favorite \| on: SQL language proposal: JOIN FOREIGN If you have specific columns that you frequently want to ignore (which, I think, is the common case of this), you could define a view that selects all the columns except those and do your queries against that view.

Eremotherium on Dec 30, 2021 [–]

Or create a function that returns a view of a table minus named columns in situ if that's really a common case for you. Just as an idea.

fendy3002 on Dec 30, 2021 | [–]

Iirc in some older db it won't be able to use indexes this way. Don't know if still applied nowadays.

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