https://kotlinlang.org logo
Title
h

hfhbd

02/15/2023, 8:48 AM
Use a view. It is very challenging to say
SELECT 'f' as FOO
is equal to
SELECT 'a' as FOO
.
h

humblehacker

02/15/2023, 3:01 PM
Thanks @hfhbd. Can you elaborate? Your example doesn't seem to relate to my question. I was referring to queries that select the same fields on the same table, but with different where clauses. How can a view help this situation?
I realized I left that crucial bit about the same fields out of my original question. I've updated it.
h

hfhbd

02/15/2023, 5:16 PM
Okay, in this case just use a view with different where clauses to get the same type (the view).
l

leandro

02/17/2023, 10:41 PM