> Did you try it? > > postgres=# SELECT '1' UNION SELECT 2; > ?column? > ---------- > 1 > 2 > (2 rows) > > Now, if I'd done this it would fail: > > postgres=# SELECT '1'::text UNION SELECT 2; > ERROR: UNION types text and integer cannot be matched > LINE 1: SELECT '1'::text UNION SELECT 2; > ^
I did try it, but probably only in the latter form through a query translator I'm working on, and also SELECT 'X' UNION SELECT 1, hoping that they would cast implicitly to a string. Sorry for the confusion and thanks for the response! James -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
