From: | Yury Don <yura(at)vpcit(dot)ru> |
---|---|
To: | pgsql-general <pgsql-general(at)postgreSQL(dot)org> |
Subject: | |
Date: | 2000-02-14 07:52:25 |
Message-ID: | 13536.000214@vpcit.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)vpcit(dot)ru
From | Date | Subject | |
---|---|---|---|
Next Message | Brian Burton-Cundall | 2000-02-14 10:14:39 | unsubscribe |
Previous Message | John Henderson | 2000-02-14 05:59:23 | typecast for index |