Thread: Incomplete description in Create Operator (function arg order must match too)

Incomplete description in Create Operator (function arg order must match too)

From

"David G. Johnston"

Date:

29 June 2015, 22:54:41

http://www.postgresql.org/docs/devel/static/plpgsql-statements.html

"""

The function_name procedure must have been previously defined using CREATE FUNCTION and must be defined to accept the correct number of arguments (either one or two) of the indicated types.

"""

This should also include a comment about "in the same order"

"...to accept the correct number of arguments (either one or two and in left to right order) of the indicated types."

Apparently the system does not attempt to find (2 arg) functions with the correct number and types of arguments but in the reverse order.

At least 9.3 appears not to...

David J.