Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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.

Jean-Gérard Pailloncy

In response to

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group