> > 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
