Re: [despammed] rejecting characters in a field

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: Andreas Kretschmer <akretschmer(at)despammed(dot)com>
Cc: PostgreSQL SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: [despammed] rejecting characters in a field
Date: 2005-06-09 07:23:18
Message-ID: 2D9E1C25-34EE-48A3-A8E7-B3DE31EFFE1B@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


On Jun 9, 2005, at 4:18 PM, Andreas Kretschmer 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.

Or a CHECK constraint on the column.

Michael Glaesemann
grzm myrealbox com

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2005-06-09 07:27:56 Re: Indices and user defined operators
Previous Message Andreas Kretschmer 2005-06-09 07:18:09 Re: [despammed] rejecting characters in a field