| From: | PG Doc comments form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Cc: | felypp(at)gmail(dot)com |
| Subject: | Describe UNION's cast on derived table |
| Date: | 2018-01-09 13:05:42 |
| Message-ID: | 20180109130542.21782.91514@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/typeconv-union-case.html
Description:
Hi!
Whilst the type conversion works great on the query ;select 10 as col1 union
select null as col1;, it does not on the almost same one ;select col1 from
(select 10 as col1) t1 union select col1 from (select null as col1) t2;,
giving the error "UNION types integer and text cannot be matched". I'm using
a 64-bit PostgreSQL 10.1 on linux.
Please, describe this situation better on the docs. Thank you so much.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2018-01-09 16:47:35 | Re: Advice on Contiguous IDs |
| Previous Message | Brian McKiernan | 2018-01-09 09:06:26 | Advice on Contiguous IDs |