By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
| table_catalog | table_schema | table_name | column_name | ordinal_position | column_default | is_nullable | data_type | character_maximum_length | character_octet_length | numeric_precision | numeric_precision_radix | numeric_scale | datetime_precision | interval_type | interval_precision | character_set_catalog | character_set_schema | character_set_name | collation_catalog | collation_schema | collation_name | domain_catalog | domain_schema | domain_name | udt_catalog | udt_schema | udt_name | scope_catalog | scope_schema | scope_name | maximum_cardinality | dtd_identifier | is_self_referencing | is_identity | identity_generation | identity_start | identity_increment | identity_maximum | identity_minimum | identity_cycle | is_generated | generation_expression | is_updatable |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| db_1633863178 | public | t | x | 1 | null | YES | text | null | 1073741824 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | db_1633863178 | pg_catalog | text | null | null | null | null | 1 | NO | NO | null | null | null | null | null | NO | NEVER | null | YES |
ERROR: column "x" is of type numeric but expression is of type text
LINE 2: set x = v.x
^
HINT: You will need to rewrite or cast the expression.
ERROR: invalid input syntax for type numeric: ""
LINE 2: set x = ''
^
ERROR: invalid input syntax for type numeric: ""
LINE 2: set x = ''::numeric
^