我正在try 查询hstore,查找与搜索条件匹配的某个键的所有值.
我可以得到某个键的所有值,如下所示:
SELECT DISTINCT
svals(slice(data, ARRAY['Supplier']))
FROM "products"
我还可以得到一个特定的值:
SELECT DISTINCT
svals(slice(data, ARRAY['Supplier'])) AS sup
FROM "products"
WHERE data @> 'Supplier => Toshiba'
我真正想要的是(这不起作用):
SELECT DISTINCT
svals(slice(data, ARRAY['Supplier'])) AS sup
FROM "products"
WHERE data @> 'Supplier => %tosh%'
或者:
SELECT DISTINCT
svals(slice(data, ARRAY['Supplier'])) AS sup
FROM "products"
WHERE lower(sup)
LIKE '%tosh%'
用于不区分大小写的搜索.这是怎么做到的?