Re: Implicitly hidden column & EXTNAME D/S

[David Gibbs <david@xxxxxxxxxxxx>]

On 5/1/20 12:19 PM, Justin Taylor wrote:
> " BTW it is never a good ide to use SELECT *!"
>
> Personally, I'd say "almost never".  Can you explain why it's better for the
> SELECT (in static SQL) to explicitly list every single column rather than
> doing SELECT *?

If a table's structure changes, and you're retrieving into host variables, you
will be either missing variables, have too many, or have mismatches.

As Brigitta says, better to list every column you want to retrieve so there is
little risk of mismatch.

david