我有以下表格:
qliu=# select id from api_member;
id
-----
242
236
246
251
253
9
21
185
49
188
我希望能够使用类似以下命令的方式删除一系列ID所在的行:
delete from api_member where id between '0' and '10';
但它不会删除任何内容。如果你有疑问的话。
delete from api_member where id between 0 and 10;
我遇到了以下错误:
ERROR: operator does not exist: character varying >= integer
LINE 1: delete from api_member where id between 0 and 10;
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
varchar
类型的列中。你所遇到的问题直接源于这个糟糕的设计决策。 - user330315