Re: union of types in a different category

>
> I prefer the explicit approach used by Postgres - MYSQL is simpler, but I'd say
> simplistic in this area. While it can automate the cating of tpes/catories of
> variable, it doesn't always do it the way I want - so I need to be explicit
> anyway.
>
> In your second use case, which fails - do you want numerics cast to strings or
> vice versa? It can make difference, so to get what you want rather than
> otherwise, I prefer to be explicit. in either Postgres or MySQL.
>

Without anything explicit, I would want them cast to text (eg in the direction of the implicit cast for the types involved). The problem is that I don't necessarily have control of the queries - they were written for MSSQL.

James