add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
?column?
2775922889
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.

oid oid oid oid
2775922889 2775922889 2775922889 2775922889
oid oid oid
2775922889 2775922889 2775922889
int4 int8
-1519044407 2775922889
ERROR:  OID out of range

ERROR:  OID out of range

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

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