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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend