Create Operator In Postgresql

Question

Anyone knows how to call self defined operator in postgresql?
I hava the following operator:

CREATE OR REPLACE FUNCTION algo.fun_temp(IN exp BOOLEAN)
RETURNS INTEGER AS $$
BEGIN
    RETURN NOT exp;
END;
$$ LANGUAGE plpgsql;

CREATE OPERATOR algo.~
(
PROCEDURE = algo.fun_temp,
RIGHTARG = BOOLEAN
);

And when I try to call this operator with SELECT algo.~ TRUE, the client complains

"ERROR:  syntax error at or near "~"
LINE 1: SELECT algo.~ TRUE"

Anyone knows what the problem is? Any help is appreciated.

cheng

Szymon Lipiński · Accepted Answer · 2012-06-19 21:17:56Z

1

The function should return INTEGER, what you wrote returns BOOLEAN:

CREATE OR REPLACE FUNCTION algo.fun_temp(IN exp BOOLEAN)
RETURNS INTEGER AS $$
BEGIN
    RETURN (NOT exp)::INTEGER;
END;
$$ LANGUAGE plpgsql;

Then add the schema algo to the search_path:

SET search_path = public, algo;

answered Jun 19, 2012 at 21:17

Szymon Lipiński

28.8k17 gold badges81 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create Operator In Postgresql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related