Re: [despammed] rejecting characters in a field - Mailing list pgsql-sql

am  09.06.2005, um  3:29:15 -0500 mailte Bruno Wolff III folgendes:
> On Thu, Jun 09, 2005 at 09:18:09 +0200,
>   Andreas Kretschmer <akretschmer@despammed.com> wrote:
> > am  09.06.2005, um 12:36:31 +0530 mailte Kenneth Gonsalves folgendes:
> > > hi
> > > i have a table with a varchar field called 'name'. I want postgres to 
> > > reject any insert with characters defined as illegal characters, for 
> > > example '*/^#'. How do i do this?
> > 
> > With a RULE or a TRIGGER.
> 
> Using a check constraint would be better a better way to do this.

Yes, okay.


Regards, Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net===    Schollglas Unternehmensgruppe    ===