Обсуждение: Help.

Поиск
Список
Период
Сортировка

Help.

От
pedro.baldanta@gmail.com
Дата:
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
Дата:
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 //