title: Postgres syntax error at or near "FILTER"
body: <p>I use PostgreSQL version 12.1 by my local machine and wrote query</p>
  
  <pre><code>SELECT cit.id, cit.city, cit.google_sheet_links,
  COALESCE(json_agg(
    json_build_object(
        'id', c_sch.id, 
        'name', c_sch.name,
        'animation', c_sch.animation,
        'headerBgColor', c_sch.header_color_bg,
        'headerTextColor', c_sch.header_color_text,
        'headerText', c_sch.header_text,
        'bodyBgColor', c_sch.body_color_bg,
        'bodyCurrencyColor', c_sch.body_color_currency,
        'bodyNumbersColor', c_sch.body_color_numbers,
        'bodyHeadersColor', c_sch.body_color_headers,
        'footerBgColor', c_sch.footer_color_bg,
        'footerColor', c_sch.footer_color_text,
        'footerText', c_sch.footer_text
      )
    )
  FILTER (WHERE c_sch.id IS NOT NULL), '[]') AS screens
  FROM public.cities cit LEFT JOIN public.color_schemes c_sch
  ON c_sch.city_id = cit.id
  GROUP BY cit.id;
  </code></pre>
  
  <p>but server using postgresql version 9.2.24 and when i want to use current query i get an error.</p>
  
  <pre><code>error: syntax error at or near "FILTER"
  </code></pre>
  
  <p>How can I fix it?</p>