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

Browse pgsql-general by date

  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