From: Tom Lane <tgl@sss.pgh.pa.us>
To: hmahmood89@googlemail.com
cc: pgsql-bugs@postgresql.org
Subject: Re: BUG #14448: create table as values - type check skipped
In-reply-to: <20161205143037.4377.60754@wrigleys.postgresql.org>
References: <20161205143037.4377.60754@wrigleys.postgresql.org>
Comments: In-reply-to hmahmood89@googlemail.com
	message dated "Mon, 05 Dec 2016 14:30:37 +0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <23048.1480962429.1@sss.pgh.pa.us>
Date: Mon, 05 Dec 2016 13:27:09 -0500
Message-ID: <23049.1480962429@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-bugs-owner@postgresql.org

hmahmood89@googlemail.com writes:
> create temporary table product_codes  as select *
> from (
> 	values
> 	('abcdefg'::character varying(20)),
> 	('012345678901234567ABCDEFGHIJKLMN')
> ) csv_data (product_code);
> select *
> from product_codes;

> I would expect that the type check got applied across all values or that the
> value got truncated.

> The result column states "character varying(20)". Inserts/Updates/Casts all
> truncate as expected.

Hmm.  I'm not sure whether that VALUES construct should be expected to
produce varchar(20) or just unrestricted varchar, but I agree that if
it claims to produce varchar(20) then the results should all meet that
limit.  Will look into it, thanks for the report!

			regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs