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