Re: 8.1.2 -32768::smallint

From: Jean-Gérard Pailloncy <jg(at)rilk(dot)com>
To: "Michael Fuhr" <mike(at)fuhr(dot)org>
Cc: Jean-Gérard Pailloncy <jg(at)rilk(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: 8.1.2 -32768::smallint
Date: 2006-12-13 16:00:25
Message-ID: 58204.82.239.202.91.1166025625.squirrel@webmail.rilk.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-12-13 16:11:06 Re: postgresql installation on centOS not working
Previous Message Michael Fuhr 2006-12-13 15:43:07 Re: 8.1.2 -32768::smallint