Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0D69964FCF6 for ; Sun, 7 Sep 2008 02:55:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 55933-09 for ; Sun, 7 Sep 2008 02:55:33 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 3EE7764FCCC for ; Sun, 7 Sep 2008 02:55:32 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m875tUs5007417; Sun, 7 Sep 2008 01:55:31 -0400 (EDT) To: "Jaime Casanova" cc: "Ryan Bradetich" , pgsql-patches Subject: Re: [PgFoundry] Unsigned Data Types [1 of 2] In-reply-to: <3073cc9b0809062246p2add97baka9252d6c32aa1d5b@mail.gmail.com> References: <3073cc9b0809061341q5c747488i85491e4c8e2420ba@mail.gmail.com> <25089.1220734677@sss.pgh.pa.us> <3073cc9b0809061610s149ef06ah5bb601b081b29db6@mail.gmail.com> <27485.1220746204@sss.pgh.pa.us> <3073cc9b0809062246p2add97baka9252d6c32aa1d5b@mail.gmail.com> Comments: In-reply-to "Jaime Casanova" message dated "Sun, 07 Sep 2008 00:46:40 -0500" Date: Sun, 07 Sep 2008 01:55:30 -0400 Message-ID: <7416.1220766930@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/82 X-Sequence-Number: 7097 "Jaime Casanova" writes: > then the patch is right but it seems to me like that is broking the > law of less surprise i expected -2::uint1 to be equivalent to > (-2)::uint1 that should be at least documented, no? See the precedence table here: http://www.postgresql.org/docs/8.3/static/sql-syntax-lexical.html#SQL-PRECEDENCE :: binds more tightly than -, and always has. regards, tom lane