Re: [despammed] rejecting characters in a field

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Andreas Kretschmer <akretschmer(at)despammed(dot)com>, PostgreSQL SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: [despammed] rejecting characters in a field
Date: 2005-06-09 08:29:15
Message-ID: 20050609082915.GA25807@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, Jun 09, 2005 at 09:18:09 +0200,
Andreas Kretschmer <akretschmer(at)despammed(dot)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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Kretschmer 2005-06-09 08:39:09 Re: [despammed] rejecting characters in a field
Previous Message Volkan YAZICI 2005-06-09 07:31:50 Re: SELECT very slow