how to insert multiple commands into a prepared statement
The problem is that putting queries together, I got this "error: cannot insert multiple commands into a prepared statement". What can I do? q1=" set search_path to care; SELECT COALESCE(c.date,a.date,jq.date,jn.date) reportmonth,registration,emailverified,application,submitted,eligible,jqtest,selected,joined from ( SELECT date_trunc(‘month’, createdon)::date as date, count(1) as registration,count(case when emailverified=’Yes’then 1 end) as emailverified from contact group by 1) full join (… Read More how to insert multiple commands into a prepared statement