Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-docs-owner+M8284=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1Z9hxE-0003tJ-LZ
 for pgsql-docs@arkaria.postgresql.org; Mon, 29 Jun 2015 22:55:08 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.84) (envelope-from
 <pgsql-docs-owner+M8284=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1Z9hxE-0003YN-09
 for pgsql-docs@arkaria.postgresql.org; Mon, 29 Jun 2015 22:55:08 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
 (Exim 4.84) (envelope-from <david.g.johnston@gmail.com>)
 id 1Z9hwm-0003Bk-Q1
 for pgsql-docs@postgresql.org; Mon, 29 Jun 2015 22:54:40 +0000
Received: from mail-ie0-x231.google.com ([2607:f8b0:4001:c03::231])
 by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
 (Exim 4.84) (envelope-from <david.g.johnston@gmail.com>)
 id 1Z9hwf-0003rs-IS
 for pgsql-docs@postgresql.org; Mon, 29 Jun 2015 22:54:40 +0000
Received: by iecuq6 with SMTP id uq6so827584iec.2
 for <pgsql-docs@postgresql.org>; Mon, 29 Jun 2015 15:54:31 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=mime-version:date:message-id:subject:from:to:content-type;
 bh=96kTTdcEs7SGnv5QL1q/tBY0tWDK43tKwI6bNZ1dKs8=;
 b=zO4Iifa/Ebu0+Tl9uk5ugizq173Pd3S9KgRY+3p1Vkwd5t/lG8F3HJMPCHsMtz/ahS
 JPmArLGGyYyP9yduA4Low15I6yNpxa78yVWG7QdR5tVmzuxiIMi2nL73zMLk3eQWFzE+
 G1kHWrvVfclJEdFwYG61Ja4pvzxioev4rHhRcAB2khAlbbAC9kz3uUxGKYoFZidvNAPX
 18ZEqOHNBRJxgpDt53hAG8jQSnQ4cr4JmTlE9OwCpMoKpnnrSviZXqeDX+RDmxo+9lPU
 mr4LLpiL+QOZG6ikLhKbQ6AwPPbJRylw7wyIhuGiX5eZOu12WYOA+wLrJIe238OwDnXg
 jzyQ==
MIME-Version: 1.0
X-Received: by 10.42.131.202 with SMTP id a10mr22454250ict.49.1435618471302;
 Mon, 29 Jun 2015 15:54:31 -0700 (PDT)
Received: by 10.36.39.203 with HTTP; Mon, 29 Jun 2015 15:54:31 -0700 (PDT)
Date: Mon, 29 Jun 2015 18:54:31 -0400
Message-ID: 
 <CAKFQuwYGrVb1oLGXJ2PfNmxnJKeyFqCMLStT2Upb1159byWkHQ@mail.gmail.com>
Subject: Incomplete description in Create Operator (function arg order must
 match too)
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: "pgsql-docs@postgresql.org" <pgsql-docs@postgresql.org>
Content-Type: multipart/alternative; boundary=bcaec552378003daca0519aff98c
X-Pg-Spam-Score: -2.7 (--)
List-Archive: <http://archives.postgresql.org/pgsql-docs>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-docs.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@postgresql.org>
List-Post: <mailto:pgsql-docs@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-docs>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
X-Mailing-List: pgsql-docs
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

--bcaec552378003daca0519aff98c
Content-Type: text/plain; charset=UTF-8

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.

--bcaec552378003daca0519aff98c
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_default" style><font face=3D"arial, he=
lvetica, sans-serif"><a href=3D"http://www.postgresql.org/docs/devel/static=
/plpgsql-statements.html">http://www.postgresql.org/docs/devel/static/plpgs=
ql-statements.html</a></font><br></div><div class=3D"gmail_default" style><=
font face=3D"arial, helvetica, sans-serif"><br></font></div><div class=3D"g=
mail_default" style=3D"font-family:arial,helvetica,sans-serif">&quot;&quot;=
&quot;</div><div class=3D"gmail_default" style><font face=3D"arial, helveti=
ca, sans-serif">The function_name procedure must have been previously defin=
ed using CREATE FUNCTION and must be defined to accept the correct number o=
f arguments (either one or two) of the indicated types.</font><br></div><di=
v class=3D"gmail_default" style><font face=3D"arial, helvetica, sans-serif"=
>&quot;&quot;&quot;</font></div><div class=3D"gmail_default" style><font fa=
ce=3D"arial, helvetica, sans-serif"><br></font></div><div class=3D"gmail_de=
fault" style><font face=3D"arial, helvetica, sans-serif">This should also i=
nclude a comment about &quot;in the same order&quot;</font></div><div class=
=3D"gmail_default" style><font face=3D"arial, helvetica, sans-serif"><br></=
font></div><div class=3D"gmail_default" style><font face=3D"arial, helvetic=
a, sans-serif">&quot;...to accept the correct number of arguments (either o=
ne or two and in left to right order) of the indicated types.&quot;</font><=
/div><div class=3D"gmail_default" style><font face=3D"arial, helvetica, san=
s-serif"><br></font></div><div class=3D"gmail_default" style>Apparently the=
 system does not attempt to find (2 arg) functions with the correct number =
and types of arguments but in the reverse order.</div><div class=3D"gmail_d=
efault" style><br></div><div class=3D"gmail_default" style>At least 9.3 app=
ears not to...</div><div class=3D"gmail_default" style><br></div><div class=
=3D"gmail_default" style>David J.</div><div class=3D"gmail_default" style><=
br></div></div>

--bcaec552378003daca0519aff98c--