Hello All,
I am writing the second time about my problem, maybe this time
somebody will answer. The problem is following:
I use a cyrillic characters in the names of tables and fields. When
I use plpgsql function as a trigger I have a record NEW in this
function, and consequently this record has a fields with cyrillic
names. But when I try to use this record, I get an error. Here is an
example.
create function round_mark() returns opaque as '
begin
NEW.Баллы:=2;
return NEW;
end;
' LANGUAGE 'plpgsql';
QUERY: create function round_mark() returns opaque as '
begin
NEW.Баллы:=2;
return NEW;
end;
' LANGUAGE 'plpgsql';
CREATE
CREATE TRIGGER marks_round_marks BEFORE INSERT OR UPDATE ON "Баллы"
FOR EACH ROW EXECUTE PROCEDURE round_mark();
QUERY: CREATE TRIGGER marks_round_marks BEFORE INSERT OR UPDATE ON "Баллы"
FOR EACH ROW EXECUTE PROCEDURE round_mark();
CREATE
UPDATE "Баллы" SET "Баллы"=264.695674 WHERE "Код" = 415;
QUERY: UPDATE "Баллы" SET "Баллы"=264.695674 WHERE "Код" = 415;
NOTICE: plpgsql: ERROR during compile of round_mark near line 2
ERROR: parse error at or near "NEW"
Does somebody know a solution?
Best regards,
Yury ICQ 11831432
mailto:yura@vpcit.ru
************