Help.

От:

pedro.baldanta@gmail.com

Дата:

11 августа 2006 г. в 09:59:53

I'd like to truncate varchar field befor insert and update.

Any example of trigger to perform this action?

Thank you.

Re: Help.

От:

Alban Hertroys <alban@magproductions.nl>

Дата:

11 августа 2006 г. в 10:05:07

pedro.baldanta@gmail.com wrote:
> I'd like to truncate varchar field befor insert and update.
> 
> Any example of trigger to perform this action?

For something as simple as that a RULE using the trim(text) function 
should work well. If that's what you're looking for.

-- 
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
    7500 AK Enschede

// Integrate Your World //