Re: [pgadmin-support] Operator script error

2012-03-13 Thread Bartosz Dmytrak
Thank You for your time. Regards, Bartek 2012/3/13 Guillaume Lelarge > On Tue, 2012-03-13 at 14:21 +0100, Bartosz Dmytrak wrote: > > Hi my script: > > Thanks. I fixed the issue. > > > -- > Guillaume > http://blog.guillaume.lelarge.info > http://www.dalibo.com > > > -- > Sent via pgadmin-suppor

Re: [pgadmin-support] Operator script error

2012-03-13 Thread Guillaume Lelarge
On Tue, 2012-03-13 at 14:21 +0100, Bartosz Dmytrak wrote: > Hi my script: Thanks. I fixed the issue. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://ww

Re: [pgadmin-support] Operator script error

2012-03-13 Thread Bartosz Dmytrak
Hi my script: CREATE OR REPLACE FUNCTION "Calc"."getDataRepository"(a text[]) RETURNS numeric AS $BODY$ DECLARE /* ARRAY STRUCTURE Metric_Name, Date, Value_Type Value_Type: 1. N - Numerator 2. D - Denominator */ vRetValue "DataRepository"."tblDataRepository"."NumeratorValue"%TYPE; vMetricN

Re: [pgadmin-support] Operator script error

2012-03-12 Thread Guillaume Lelarge
On Mon, 2012-03-12 at 14:51 +0100, Bartosz Dmytrak wrote: > Hi, > it looks like operator script is generated incorrectly: > eg. > -- Operator: Calc.@#(NONE, _text) -- Lack of quotation > > -- DROP OPERATOR Calc.@#(NONE, _text); -- Lack of quotation > > CREATE OPERATOR Calc.@#( > PROCEDURE = """

[pgadmin-support] Operator script error

2012-03-12 Thread Bartosz Dmytrak
Hi, it looks like operator script is generated incorrectly: eg. -- Operator: Calc.@#(NONE, _text) -- Lack of quotation -- DROP OPERATOR Calc.@#(NONE, _text); -- Lack of quotation CREATE OPERATOR Calc.@#( PROCEDURE = """Calc"".""doSomething""", -- Wrong quotation RIGHTARG = _text); COMMENT ON