>
> 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