"Edwin Quijada" <[EMAIL PROTECTED]> writes:
> I got error about a length field varchar. I have a table with a field type
> varchar(20) but if I try to set to this field more than 20 characters I got
> error.
> I did a function to control the length of data and put it on trigger but
> when it ocu
At 05:06 PM 10/29/03 +, Edwin Quijada wrote:
wHAT IS unconstrained varchar???
Define the column as just varchar. This allows a string of any
length. Then have a trigger truncate it after it is inserted.
--- Adam Kavan
--- [EMAIL PROTECTED]
---(end of broadcast)-
comun"
*---*
From: Tom Lane <[EMAIL PROTECTED]>
To: "Edwin Quijada" <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Error size varchar Date: Wed, 29 Oct 2003 11:28:23
-0500
"Edwin Quijada" <[EMAIL PROTECTED]> writes:
> I got error
Hi!!
I got error about a length field varchar. I have a table with a field type
varchar(20) but if I try to set to this field more than 20 characters I got
error.
I did a function to control the length of data and put it on trigger but
when it ocurrs I got the error anyway and the trigger no