Re: union of types in a different category

> 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