Postgres Pro
Downloads
Home   >   mailing lists

Incomplete description in Create Operator (function arg order must match too) - Mailing list pgsql-docs

From David G. Johnston
Subject Incomplete description in Create Operator (function arg order must match too)
Date
Msg-id CAKFQuwYGrVb1oLGXJ2PfNmxnJKeyFqCMLStT2Upb1159byWkHQ@mail.gmail.com
Whole thread Raw
List pgsql-docs
Tree view
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.

pgsql-docs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Omission of "(or C)" in psql's "pset title" header
Next
From: Monica Gamazo
Date:
Subject: Re: Omission of "(or C)" in psql's "pset title" header