Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id CF9451337B61 for ; Wed, 4 May 2011 15:36:18 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 59004-10 for ; Wed, 4 May 2011 18:36:11 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-iw0-f174.google.com (mail-iw0-f174.google.com [209.85.214.174]) by mail.postgresql.org (Postfix) with ESMTP id 743001337BD3 for ; Wed, 4 May 2011 15:36:11 -0300 (ADT) Received: by iwn34 with SMTP id 34so1189236iwn.19 for ; Wed, 04 May 2011 11:36:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:date:message-id:subject:from:to :content-type; bh=2jueMqYRM98Nwx71pyY1XykSKJFf+2E6GpM9oR+j5N8=; b=i8NuNg5xNCkoVtI3Vjg/nU90c5uKkc67oZUsSvCR0fjJNZ/DjWu1dqyeeiF2B/Sj+8 iZJaj622XiRpuyNDPUfMFbiuwhP16VBvoaTkGYHK83FcmFp5cA3uklACR2b8CqkZ8ueN /mcihIbh3/aGxPYfP+7eJx1nD0814IX4i0kiA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=EghRwoSb7lUTko7r0+CgAzZ9u5lScy5hvBy+7UqZpV1szyJqcXYDMi76H3km8OmXur r+lFDTC2CxbizgF+8xSVP+cdPrRcVb45j20tDeRErbfZTZ97+beoETtdtBH1hH7B/Skb PEt2v+6dR8FEw59irRR8jGQTXZFoojtlFYTxs= MIME-Version: 1.0 Received: by 10.231.203.212 with SMTP id fj20mr489699ibb.15.1304534170939; Wed, 04 May 2011 11:36:10 -0700 (PDT) Received: by 10.231.37.2 with HTTP; Wed, 4 May 2011 11:36:10 -0700 (PDT) Date: Wed, 4 May 2011 20:36:10 +0200 Message-ID: Subject: Missing prefix unary '+' operator in Table 4-2 ? From: Grzegorz Szpetkowski To: pgsql-docs@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.888 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RFC_ABUSE_POST=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201105/8 X-Sequence-Number: 6683 I have question about Table 4-2. Operator Precedence (decreasing) on http://www.postgresql.org/docs/9.0/static/sql-syntax-lexical.html. I see there is '-' unary (unary minus) operator listed, but I can't see '+' (unary plus) prefix operator there. I think that it does not belong to "(any other)" group as: SELECT 5 ! + 6; ERROR: operator does not exist: integer ! integer LINE 1: SELECT 5 ! + 6; Regards, Grzegorz Szpetkowski