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;
^