Postgres Pro
Downloads
Home   >   mailing lists

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

From Andreas Kretschmer
Subject Re: [despammed] rejecting characters in a field
Date
Msg-id 20050609071809.GB303@webserv.wug-glas.de
Whole thread Raw
In response to rejecting characters in a field  (Kenneth Gonsalves <lawgon@thenilgiris.com>)
Responses Re: [despammed] rejecting characters in a field  (Michael Glaesemann <grzm@myrealbox.com>)
Re: [despammed] rejecting characters in a field  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-sql
Tree view 
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.


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

pgsql-sql by date:

Previous
From: Gnanavel Shanmugam
Date:
Subject: Re: rejecting characters in a field
Next
From: Michael Glaesemann
Date:
Subject: Re: [despammed] rejecting characters in a field