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: 58204.82.239.202.91.1166025625.squirrel@webmail.rilk.com (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group