Body: <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>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-06-22T09:49:19.203Z
Comments.Text: 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`.
Comments.UserDisplayName: terdon
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-06-22T09:49:46.700Z
Comments.Text: I’m voting to close this question because it is about SQL and not related to bioinformatics.
Comments.UserDisplayName: terdon
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-06-22T12:13:53.593Z
Comments.Text: 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.
Comments.UserDisplayName: Community
Tags: <database>
Title: postgreSQL error: "ERROR: invalid input syntax for type numeric: NULL"
ThreadText: # 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
  
  