Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id CD169632ED6 for ; Thu, 8 Jul 2010 11:28:42 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 98552-07 for ; Thu, 8 Jul 2010 14:28:34 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com [74.125.82.174]) by mail.postgresql.org (Postfix) with ESMTP id 586FE632CC3 for ; Thu, 8 Jul 2010 11:28:35 -0300 (ADT) Received: by wyf23 with SMTP id 23so590935wyf.19 for ; Thu, 08 Jul 2010 07:28:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:from:to:subject:date :user-agent:mime-version:content-type:content-transfer-encoding :message-id; bh=C0PmvklXpcr5CTNIZ2s9C/exwdy52BYJng1lr61k80E=; b=wMuRb4vRn6KbWOUHrO8yNs4Wpz5NXwJpcRL3BZijVb2R2uQ4bQhbqJjdwVFm8vweU/ uxdJaqDICQHh8/uwOeTllyW50MnMH4/22EUSqIobu9HhMwSAmFChcWNUzqtKzprATn/u 7t+m2+3dhiaq+opzLlwkWK/LReNvLW7n7nwIg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=from:to:subject:date:user-agent:mime-version:content-type :content-transfer-encoding:message-id; b=vAcYcn9M/ukAGbumfgaluPyn/lbpIbqoRXFXHr2D9zJ9figFAKelxo6Q2KCFJomb3e f6sfN4YFbV5/NoPEaOC3lIUMVpMneoAJ1mvufArihXeZV+1i3BfTcLSDdzjI5UJJpu58 NjLApOY9VSgxkfIx3lBjaXGH69/eeQfbZMvjs= Received: by 10.216.185.143 with SMTP id u15mr2498756wem.21.1278599312988; Thu, 08 Jul 2010 07:28:32 -0700 (PDT) Received: from marco-dalibo.localnet (gev44-1-78-228-108-65.fbx.proxad.net [78.228.108.65]) by mx.google.com with ESMTPS id o69sm1189395wej.41.2010.07.08.07.28.32 (version=SSLv3 cipher=RC4-MD5); Thu, 08 Jul 2010 07:28:32 -0700 (PDT) From: Marc Cousin To: pgsql-docs@postgresql.org Subject: =?iso-8859-1?q?CREATE=A0OPERATOR_and?= precedence Date: Thu, 8 Jul 2010 16:28:30 +0200 User-Agent: KMail/1.13.5 (Linux/2.6.34-ARCH; KDE/4.4.5; x86_64; ; ) MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Message-Id: <201007081628.30860.cousinmarc@gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201007/65 X-Sequence-Number: 5721 Hi, I just got caught by a precedence problem with CREATE OPERATOR. Obviously, it was mostly my fault (I didn't think of the precedence of my=20 operator at all), but I didn't find anything in the CREATE OPERATOR=20 documentation about it either. =46rom looking at the code, I think I understood that it has a very low=20 precedence, but shouldn't it be specified in the documentation (so that at= =20 least distracted people like me think of precedence next time they create a= n=20 operator :) ) ? Cheers Marc