Thread: Help.

Help.

From

pedro.baldanta@gmail.com

Date:

11 August 2006, 12: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.

From

Alban Hertroys

Date:

11 August 2006, 13: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 //