insect.sql

WITH
                sel AS (SELECT id, key, value FROM labels WHERE (key = 'sequencing_strandness' AND value = 'paired-end')),
                ins AS (
                  INSERT INTO "labels"(key, value)
                  SELECT key, value
                  WHERE NOT EXISTS (SELECT 1 FROM sel)
                  RETURNING "id", key, value
                )
              SELECT * FROM ins UNION ALL SELECT * FROM sel
;
ERROR:  column "key" does not exist
LINE 5:                   SELECT key, value
                                 ^
HINT:  There is a column named "key" in table "labels", but it cannot be referenced from this part of the query.
Time: 2.784 ms