Postgres 12

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT 2^32 - 1519044407;


?column?


2775922889


-- fails as expected:
SELECT -1519044407::oid;
ERROR:  operator does not exist: - oid
LINE 2: SELECT -1519044407::oid;
               ^
HINT:  No operator matches the given name and argument type. You might need to add an explicit type cast.


-- (surprisingly!) works:
SELECT '-1519044407'::oid, '-1519044407'::int::oid, oid '-1519044407', (int '-1519044407')::oid;
     


oid
oid
oid
oid


2775922889
2775922889
2775922889
2775922889


-- works as expected
SELECT 2775922889::oid, '2775922889'::oid, oid '2775922889';


oid
oid
oid


2775922889
2775922889
2775922889


-- differs!
SELECT (oid '2775922889')::int
     , (oid '2775922889')::bigint;


int4
int8


-1519044407
2775922889


-- fails as expected:
SELECT '-1519044407'::bigint::oid;
ERROR:  OID out of range


-- fails as expected:
SELECT (bigint '-1519044407')::oid
ERROR:  OID out of range


-- fails as expected:
SELECT '-1519044407'::numeric::oid;
ERROR:  cannot cast type numeric to oid
LINE 2: SELECT '-1519044407'::numeric::oid;
                                     ^


-- fails as expected:
SELECT '-1519044407'::float8::oid;
ERROR:  cannot cast type double precision to oid
LINE 2: SELECT '-1519044407'::float8::oid;
                                    ^