Re: Automatic truncation of character values & casting to the type of a column type

Justin Bailey <jgbailey@gmail.com> writes:
> I have tried using the PL/PGSQL
> feature where types can be "copied" in a declaration:

>   DECLARE
>      myVal Short.shortCol%TYPE;

> But I can still put values which are too long into that variable, so
> it doesn't help me.

Really?  Works for me, in everything back to 7.3.

            regards, tom lane