[EMAIL PROTECTED] wrote:
I would want to replace "bv" values with FALSE when insert/update
NULL value for
this field.
You could do this by having the application insert to a view with a
rule that replaces null bv values before redirecting to the base table.
Is more functional to create a Rule instead of a trigger?
It's different - you can think of a rule as a kind of macro, rewriting
the query the application provides. Make sure you read the manuals
carefully to be sure you understand how they work though.
Or need I create a TRIGGER that check it and replace the itens???
CREATE or REPLACE function TG_table1_check RETURNS trigger as '
BEGIN
IF nullvalue(NEW.bv) THEN
IF NEW.bv IS NULL THEN
What is the difference between nullvalue() and IS NULL???
"IS NULL" is a standard SQL expression.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
