SELECT x'00000000F'::int leading zeros causes "integer out of range"

[Justin Pryzby <pryzby@xxxxxxxxxxxxx>]

Is this expected behavior ?

This works:

	ts=# SELECT x'0000000F'::int;
	int4|15

.. but an additional leading zero causes it to fail:

	ts=# SELECT x'00000000F'::int;
	ERROR:  22003: integer out of range
	LOCATION:  bittoint4, varbit.c:1575


|/* Check that the bit string is not too long */
|if (VARBITLEN(arg) > sizeof(result) * BITS_PER_BYTE)
|	ereport(ERROR,
|			(errcode(ERRCODE_NUMERIC_VALUE_OUT_OF_RANGE),
|			 errmsg("integer out of range")));

Justin


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general