类似于:
SELECT * FROM table WHERE something IN ('{"val1","val2"}'::text[]);
我try 了使用ARRAY_TO_STRING().
SELECT * FROM table WHERE something IN (array_to_string('{"val1","val2"}'::text[]));
但我想这就到了这个地步:
SELECT * FROM table WHERE something IN ('val1,val2'); --one single string
我想单一值还必须用撇号括起来.
这是可能的,还是可以用一种完全不同的方式解决?