CAST truncates without warning

[Mike G]

Hello,

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

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

Mike


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Tom Lane]

Mike G <mi**@thegodshalls.com> writes:

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

No. This is per SQL spec.

You will get a warning if you assign the value to a varchar(20) table
column *without* any explicit cast. This is also per SQL spec.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html