CAST truncates without warning - Mailing list pgsql-general

From Mike G
Subject CAST truncates without warning
Date
Msg-id 20040513204415.GA22637@localhost.localdomain
Whole thread Raw
Responses Re: CAST truncates without warning  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hello,

If a column, data type text, with 22 characters of data, is then CAST(column_name as varchar(20)) shouldn't a warning
orerror be generated? 

If the source is a variable defined as text instead of directly from a table, using plpsql, would that matter?

Mike




pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: setting local time without restarting server
Next
From: Tom Lane
Date:
Subject: Re: CAST truncates without warning