Postgres Pro
Downloads
Home   >   mailing lists

Re: 8.1.2 -32768::smallint - Mailing list pgsql-bugs

From Jean-Gérard Pailloncy
Subject Re: 8.1.2 -32768::smallint
Date
Msg-id 58204.82.239.202.91.1166025625.squirrel@webmail.rilk.com
Whole thread Raw
In response to Re: 8.1.2 -32768::smallint  (Michael Fuhr <mike@fuhr.org>)
List pgsql-bugs
Tree view 
> select -(32768::smallint)
>
> which is why you're getting "smallint out of range."  This should work:
>
> select (-32768)::smallint
Exact. Thank you for the answer.
But really conter-intuitive.

Cordialement,
Jean-Gérard Pailloncy

pgsql-bugs by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: 8.1.2 -32768::smallint
Next
From: Tom Lane
Date:
Subject: Re: postgresql installation on centOS not working