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, Andre
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
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?
--
regards
kg
http://www.livejournal.com/users/lawgon
tally ho! http://avsap.sourceforge.net
ಇಂಡ್ಲಿನಕ್ಸ வாழ்க!
---
add check constraint with following pattern
check(name !~ '[*/^#]')
with regards,
S.Gnanavel
> -Original Message-
> From: [EMAIL PROTECTED]
> Sent: Thu, 9 Jun 2005 12:36:31 +0530
> To: pgsql-sql@postgresql.org
> Subject: [SQL] rejecting characters in a fiel