wHAT IS unconstrained varchar???
*-------------------------------------------------------*
*-Edwin Quijada
*-Developer DataBase
*-JQ Microsistemas
*-809-747-2787
* " Si deseas lograr cosas excepcionales debes de hacer cosas fuera de lo 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 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 not works.
The length constraint is checked before triggers are fired, I believe. If you want silent truncation rather than an error, use a text column (or unconstrained varchar) and put the truncation behavior into your trigger.
regards, tom lane
_________________________________________________________________
Fretting that your Hotmail account may expire because you forgot to sign in enough? Get Hotmail Extra Storage today! http://join.msn.com/?PAGE=features/es
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
