1
$\begingroup$

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?

Improve this question
$\endgroup$
3
  • $\begingroup$ 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. $\endgroup$
    – terdon ♦
    Commented Jun 22, 2022 at 9:49
  • 4
    $\begingroup$ I’m voting to close this question because it is about SQL and not related to bioinformatics. $\endgroup$
    – terdon ♦
    Commented Jun 22, 2022 at 9:49
  • $\begingroup$ 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. $\endgroup$
    – Community Bot
    Commented Jun 22, 2022 at 12:13

0

Reset to default

Browse other questions tagged or ask your own question.