Todd Reed ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is.
Short Description CREATE TABLE AS ignores explicit column names with UNION Long Description CREATE TABLE AS ignores explicitly specified column names when the query contains a UNION. This is illustrated in the example below. I am using 7.2.1 on RedHat Linux 7.2. Sample Code template1=# create table foo ( template1(# x int, template1(# y int, template1(# z int template1(# ); CREATE template1=# create table bar ( template1(# a int, template1(# b int, template1(# c int template1(# ); CREATE template1=# create table snafu (s, u, t) as template1-# select x, y, z from foo union select a, b, c from bar; SELECT template1=# create table spam (s, u, t) as template1-# select x, y, z from foo; SELECT template1=# select * from snafu; x | y | z ---+---+--- (0 rows) template1=# select * from spam; s | u | t ---+---+--- (0 rows) No file was uploaded with this report ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
