Hello All,
create function round_mark() returns opaque as '
begin
NEW."<natioanl characters field name>" := 1;
return NEW;
end;
' LANGUAGE 'plpgsql';
CREATE
CREATE TRIGGER marks_round_marks BEFORE INSERT OR UPDATE ON "rr"
FOR EACH ROW EXECUTE PROCEDURE round_mark();
CREATE
UPDATE "rr" SET "РР"=1 WHERE "РР" = 1;
NOTICE: plpgsql: ERROR during compile of round_mark near line 1
ERROR: unterminated "
Best regards,
Yury ICQ 11831432
mailto:yura(at)vpcit(dot)ru