Re: [GENERAL] Error size varchar

2003-10-29 Thread Tom Lane
"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

Re: [GENERAL] Error size varchar

2003-10-29 Thread Adam Kavan
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)-

Re: [GENERAL] Error size varchar

2003-10-29 Thread Edwin Quijada
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

[GENERAL] Error size varchar

2003-10-29 Thread Edwin Quijada
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