SEO

#1 (**permalink**) 04-09-2008, 10:59 AM

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

Any example of trigger to perform this action?

Thank you.

#2 (**permalink**) 04-09-2008, 10:59 AM

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 //

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Help.