On Fri, Feb 24, 2017 at 2:13 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Justin Pryzby <pry...@telsasoft.com> writes: > > Is this expected behavior ? > > ts=# SELECT x'00000000F'::int; > > ERROR: 22003: integer out of range > > LOCATION: bittoint4, varbit.c:1575 > > Yes. The provided operation is "convert a bitstring of up to 32 bits > to an integer". It's not "guess whether it's okay to throw away some > bits to make an integer". > > As an example, even if you think it's obvious that it would be okay > to convert that bitstring to "15", would it be all right to convert > x'FFFFFFFFF' to "-1" ? > > regards, tom lane > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > In addition to what Tom said SELECT x'00000000F'::bigint; works just fine. IOW, int = 4 bytes, while bigint = 8 bytes. -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.
