Weighing/Valuing shared strings using count on text array columns in Postgresql
you can replace count(*) by:
sum (
case tag
when 'Financial Services'
then 3
when 'other 3 points tag'
then 3
else 1
end)
Weighing/Valuing shared strings using count on text array columns in Postgresql
you can replace count(*) by:
sum (
case tag
when 'Financial Services'
then 3
when 'other 3 points tag'
then 3
else 1
end)