<p>I'm new to SQL. I have a table with a column of <strong>numeric</strong>  type that include NULL values. I built the table structure in postgresql, when I try to import my table I get the following error:</p>
<p><code>ERROR: invalid input syntax for type numeric: NULL</code></p>
<p>I tried both</p>
<p><code>UPDATE MY_TABLE  SET MY_COLUMN = CAST(NULL AS NUMERIC)</code></p>
<p>and setting manually the default value of the column as NULL, but none of them are working.
Is there another way to handle this problem?</p>

CC BY-SA 4.0
2022-06-22T09:49:19.203Z
Hi and welcome to the site! We only deal with questions about bionformatics here and this looks like a very standard SQL question with no connection to bioinformatics so I am afraid it is off topic. That said, I suspect you just want `UPDATE MY_TABLE  SET MY_COLUMN = NULL`.
terdon
CC BY-SA 4.0
2022-06-22T09:49:46.700Z
I’m voting to close this question because it is about SQL and not related to bioinformatics.
terdon
CC BY-SA 4.0
2022-06-22T12:13:53.593Z
Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking.
Community
<database>
postgreSQL error: "ERROR: invalid input syntax for type numeric: NULL"
# postgreSQL error: "ERROR: invalid input syntax for type numeric: NULL"

(Asked by: username_0 on 2022-06-22)

I'm new to SQL. I have a table with a column of **numeric** type that include NULL values. I built the table structure in postgresql, when I try to import my table I get the following error:

`ERROR: invalid input syntax for type numeric: NULL`

I tried both

`UPDATE MY_TABLE SET MY_COLUMN = CAST(NULL AS NUMERIC)`

and setting manually the default value of the column as NULL, but none of them are working.
Is there another way to handle this problem?

**Tags:** database
> **Comments:**
> **username_1**: Hi and welcome to the site! We only deal with questions about bionformatics here and this looks like a very standard SQL question with no connection to bioinformatics so I am afraid it is off topic. That said, I suspect you just want `UPDATE MY_TABLE  SET MY_COLUMN = NULL`.  
> **username_1**: I’m voting to close this question because it is about SQL and not related to bioinformatics.  
> **username_2**: Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking.  

---

## 0 answers

