Re: why commutator doesn't work?

2018-10-29 Thread Pavel Stehule
po 29. 10. 2018 v 7:35 odesílatel Fabien COELHO napsal: > > Hello Pavel, > > > I try to create operator + for varchar and integer with Oracle behave. > > > > create or replace function sum(varchar, int) > > returns int as $$ select $1::int + $2 $$ language sql; > > > > create operator +

Re: why commutator doesn't work?

2018-10-29 Thread Fabien COELHO
Hello Pavel, I try to create operator + for varchar and integer with Oracle behave. create or replace function sum(varchar, int) returns int as $$ select $1::int + $2 $$ language sql; create operator + (function = sum, leftarg = varchar, rightarg = int, commutator = +); create table

why commutator doesn't work?

2018-10-28 Thread Pavel Stehule
Hi I try to create operator + for varchar and integer with Oracle behave. create or replace function sum(varchar, int) returns int as $$ select $1::int + $2 $$ language sql; create operator + (function = sum, leftarg = varchar, rightarg = int, commutator = +); create table foo2(a varchar);