postgresql 判断是空的_postgresql-如何查询json列中的空对象？

寻找所有的行，其中某个json列包含一个空对象{}。这对于JSON数组或在对象中查找特定键是可能的。 但是我只想知道对象是否为空。 似乎找不到可以执行此操作的运算符。

dev=# \d test

Table "public.test"

Column | Type | Modifiers

--------+------+-----------

foo | json |

dev=# select * from test;

foo

---------

{"a":1}

{"b":1}

{}

(3 rows)

dev=# select * from test where foo != '{}';

ERROR: operator does not exist: json <> unknown

LINE 1: select * from test where foo != '{}';

^

HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

dev=# select * from test where foo != to_json('{}'::text);

ERROR: operator does not exist: json <> json

LINE 1: select * from test where foo != to_json('{}'::text);

^

HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

dwv=# select * from test where foo != '{}'::json;

ERROR: operator does not exist: json <> json

LINE 1: select * from test where foo != '{}'::json;

^

HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.