-- Giving a query to run_iok_queries runs only those queries. BEGIN; -- Omit the role, search_path, and (non-NULL) timestamps from the -- column list, they change and cause the test to fail. SELECT irid, iqname, deferred_to, category , keep_until, qr_id, qr_message, qr_extra, notes FROM run_isok_queries($$VALUES ('query1');$$) AS riq ORDER BY riq.irid; irid | iqname | deferred_to | category | keep_until | qr_id | qr_message | qr_extra | notes ------+--------+-------------+----------+------------+-------+-----------------+----------+------- 1 | query1 | | | | R1 | Result number 1 | | 2 | query1 | | | | R2 | Result number 2 | | 3 | query1 | | | | R3 | Result number 3 | | (3 rows) ROLLBACK; -- Cleanup -- Reset the sequence so what this test did is ignored. SELECT setval('isok_results_irid_seq', 1, FALSE); setval -------- 1 (1 row)