[DOCS] CREATE OPERATOR query

2013-05-21 Thread Robins Tharakan
hese operators. Any pointers would be helpful. Thanks -- Robins Tharakan

Re: [DOCS] CREATE OPERATOR query

2013-05-21 Thread Robins Tharakan
S $$ SELECT NULL::type_op3; $$ LANGUAGE sql IMMUTABLE; REVOKE EXECUTE ON FUNCTION fn_op3(type_op3, type_op3) FROM rol_op3; SET ROLE rol_op3; CREATE OPERATOR #*# ( leftarg = type_op3, rightarg = type_op3, procedure = fn_op3 ); RESET ROLE; ROLLBACK; Thanks. -- Robins Tharakan On 22 M

Re: [DOCS] CREATE OPERATOR query

2013-05-21 Thread Robins Tharakan
ing function. If a commutator or negator operator is specified, you must own these operators. Am I missing something obvious here? -- Robins Tharakan On 22 May 2013 07:12, Alvaro Herrera wrote: > Robins Tharakan escribió: > > Further, I seem to have a similar problem with the E

Re: [DOCS] CREATE OPERATOR query

2013-05-22 Thread Robins Tharakan
Makes perfect sense. Thanks and appreciate a prompt response. Would update the tests accordingly. -- Robins Tharakan On 22 May 2013 09:03, Alvaro Herrera wrote: > Robins Tharakan escribió: > > Yes, but the documentation states that EXECUTE permission for the > function > > i