title: psycopg returns empty query result when there is data
body: <p>I'm trying to get records from the postgressql query below. It does have data but when I tried to retrieve it with psycopg, weirdly it returns empty. Does it work with WITH query or we can only use SELECT instead? Any input would be appreciated, thank you.</p>
  <pre><code>query = \
          f&quot;&quot;&quot; WITH a AS (
              SELECT &quot;public&quot;.&quot;table_a&quot;.&quot;code&quot;, 
              &quot;public&quot;.&quot;table_a&quot;.&quot;address&quot;, sum(&quot;public&quot;.&quot;table_a&quot;.&quot;amount&quot;) AS 
              &quot;sum&quot; FROM &quot;public&quot;.&quot;table_a&quot; WHERE &quot;public&quot;.&quot;table_a&quot;.&quot;address&quot; &lt;&gt; 'KL' GROUP BY 
              &quot;public&quot;.&quot;table_a&quot;.&quot;code&quot;, &quot;public&quot;.&quot;table_a&quot;.&quot;address&quot;), 
              c as (
                  WITH b AS ( 
                  SELECT address, code, count(*) as &quot;total&quot; FROM table_b where created_date between 
                  ((current_date + TIME '14:00:00.000+08:00') - interval '7 days') and ((
                  current_date + TIME '23:59:00.000+08:00') - interval '7 days') group by 
                  address, code order by address, code) 
                  select b.address, table_c.unit_code, table_c.name, sum(b.total * 
                  table_c.amount) as &quot;total&quot; from table_c join b on table_c.code = b.code 
                  group by table_c.unit_code, table_c.name, b.address 
                  order by table_c.unit_code, b.address
                  )
              SELECT a.address, a.code, (a.sum - c.total)::int as output
              FROM a join c on a.code = c.unit_code
              AND a.address = c.address
              ORDER BY a.address, a.code 
  &quot;&quot;&quot;
  
  conn = psycopg2.connect(**params)
          cur = conn.cursor()
          cur.execute(query)
  rows = cur.fetchall()
  for row in rows:
              print(row)
  </code></pre>