> This executes query and discards the result. Write the query the same way you would write an SQL SELECT command, but replace the initial keyword SELECT with PERFORM. For WITH queries, use PERFORM and then place the query in parentheses. (In this case, the query can only return one row.)
But that only works for a single returned value (one column of one row). Else we need to treat the WITH query like a subquery with alias. There was a related question on Stackoverflow:
For WITH queries, use PERFORM and place the query in parentheses. If the query returns more than a single value (one column of one row) you must treat it as subquery, writing PERFORM * FROM (query) my_alias;
