Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id F172B64FCC3 for ; Sun, 7 Sep 2008 03:30:57 -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 67474-04 for ; Sun, 7 Sep 2008 03:30:55 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.226]) by postgresql.org (Postfix) with ESMTP id CD38064FCC2 for ; Sun, 7 Sep 2008 03:30:54 -0300 (ADT) Received: by rv-out-0506.google.com with SMTP id b25so1431767rvf.43 for ; Sat, 06 Sep 2008 23:30:53 -0700 (PDT) Received: by 10.140.249.20 with SMTP id w20mr7935253rvh.103.1220769053398; Sat, 06 Sep 2008 23:30:53 -0700 (PDT) Received: by 10.141.51.11 with HTTP; Sat, 6 Sep 2008 23:30:53 -0700 (PDT) Message-ID: <3073cc9b0809062330o62fd74dax74b1730cedc0fbb9@mail.gmail.com> Date: Sun, 7 Sep 2008 01:30:53 -0500 From: "Jaime Casanova" To: "Ryan Bradetich" Subject: Re: [PgFoundry] Unsigned Data Types [1 of 2] Cc: pgsql-patches In-Reply-To: <3073cc9b0809061341q5c747488i85491e4c8e2420ba@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <3073cc9b0809061341q5c747488i85491e4c8e2420ba@mail.gmail.com> 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/83 X-Sequence-Number: 7098 On Sat, Sep 6, 2008 at 3:41 PM, Jaime Casanova wrote: > > i still have to make some more test... > why i need the cast in this case? even if the cast is really necesary (the message seems realy ugly) contrib_regression=3D# select * from t1 where f1 > 35; ERROR: unsupported type: 16486 contrib_regression=3D# select * from t1 where f1 > 35::uint4; f1 ----- 36 37 38 --=20 regards, Jaime Casanova Soporte y capacitaci=F3n de PostgreSQL Asesor=EDa y desarrollo de sistemas Guayaquil - Ecuador Cel. (593) 87171157