UPDATE table_name SET col_name = varchar WHERE col_name 为 NULL; [英] UPDATE table_name SET col_name = varchar WHERE col_name is NULL;

问题描述

以下更新失败:-

UPDATE table_name SET col_name = varchar WHERE col_name is NULL;

失败信息是:-

ERROR:  column "varchar" does not exist

虽然下面提到的成功了:-

Whereas the undermentioned one succeeds :-

UPDATE table_name SET col_name = 889977 WHERE col_name is NULL;

我已经检查了列的 pg_typeof - col_name 是 character 变量.请帮忙.

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

推荐答案

我想你错过了对字符串的引用

i think you missed quote for string

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

这篇关于UPDATE table_name SET col_name = varchar WHERE col_name 为 NULL;的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！