UPDATE table_name SET col_name = varchar WHERE col_name is NULL;

Question

The following UPDATE fails :-

UPDATE table_name SET col_name = varchar WHERE col_name is NULL;

The failure message is :-

ERROR:  column "varchar" does not exist

Whereas the undermentioned one succeeds :-

UPDATE table_name SET col_name = 889977 WHERE col_name is NULL;

I have checked the pg_typeof of the column - col_name is character varying. Kindly help.

Answer 1

i think you missed quote for string

UPDATE table_name SET col_name = 'varchar' WHERE col_name is NULL;