Postgres Pro
Downloads
Home   >   mailing lists

Re: Automatic truncation of character values & casting to the type of a column type - Mailing list pgsql-general

From Tom Lane
Subject Re: Automatic truncation of character values & casting to the type of a column type
Date
Msg-id 21710.1261020051@sss.pgh.pa.us
Whole thread Raw
In response to Automatic truncation of character values & casting to the type of a column type  (Justin Bailey <jgbailey@gmail.com>)
Responses Re: Automatic truncation of character values & casting to the type of a column type  (Justin Bailey <jgbailey@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: yuliada
Date:
Subject: Re: Slow select
Next
From: Pavel Stehule
Date:
Subject: Re: How to get text for a plpgsql variable from a file.