我有一个查询,我在DISTINCT ON中使用CASE语句,如下所示: SELECT
DISTINCT ON(COALESCE(users.cuid,events.uid),CASEWHEN events.props->>'prop' IS NULL THEN '$none' WHEN events.props->>'prop' = '' THEN '$none
索引存在于连接语句中的所有列上:coalesce(temp_decmetadata.glare_roadGlare, 0) as glare_roadGlarefiles( count(casewhen glare like '%roadGlare%' then 1 end) as glare_roadGlare,
count(casewhen glare like