Re: [despammed] rejecting characters in a field

Поиск
Список
Период
Сортировка
От Andreas Kretschmer
Тема Re: [despammed] rejecting characters in a field
Дата
Msg-id 20050609083909.GI303@webserv.wug-glas.de
обсуждение исходный текст
Ответ на Re: [despammed] rejecting characters in a field  (Bruno Wolff III <bruno@wolff.to>)
Список 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    === 


В списке pgsql-sql по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: [despammed] rejecting characters in a field
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: SELECT very slow