"Bernhard Reutner-Fischer" <rep(dot)dot(dot)nop(at)gmail(dot)com> writes:
> Fair enough but what about the failure for the case with the Result
> that fails to merge? There I do have a cast
No you don't:
> select * from (select 'string two' bug ) s2
regards, tom lane