> Is there a way to include a column in a SELECT but substitute a value if
> it doesn't? I need my code to work with different versions of my db schema.
>
> eg I want to SELECT A, B, C, ... but C might not exist.
>
> SELECT * would work of course, except it will fetch a bunch of columns I
> don't need.

You can read the list of fields available in advance and modify your
query ommitting missing columns.


Elmar