pl/pgsql and national characters

From: Yury Don <yura(at)vpcit(dot)ru>
To: pgsql-general <pgsql-general(at)postgreSQL(dot)org>
Subject: pl/pgsql and national characters
Date: 2000-02-04 10:39:31
Message-ID: 10652.000204@vpcit.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello All,

I have a following problem. I have a tables and fields whith names,
consisting of cyrillic characters and getting an error. When I am
doing the same things but with only english characters, everything ok.
All other things works properly, only pl/pgsql functions. Does anybody
knows how to treat this?
Here is an example:

create function round_mark() returns opaque as '
begin
NEW."<cyrillic characters>" := 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 "<cyrillic characters>"=1 WHERE "<cyrillic characters>" = 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

Browse pgsql-general by date

  From Date Subject
Next Message Marc Tardif 2000-02-04 12:21:51 Re: [GENERAL] max query length
Previous Message Yury Don 2000-02-04 10:32:20 pl/pgsql and national characters