Re: Error size varchar

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 <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>To: "Edwin Quijada" <listas_quijada(at)hotmail(dot)com>
>CC: pgsql-general(at)postgresql(dot)org
>Subject: Re: [GENERAL] Error size varchar Date: Wed, 29 Oct 2003 11:28:23
>-0500
>
>"Edwin Quijada" <listas_quijada(at)hotmail(dot)com> 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