ids-arg-named.sql « queryrow « test « sql « dbstore - cvez - Unnamed repository; edit this file 'description' to name the repository.

about summary refs log tree commit diff

path: root/dbstore/sql/test/queryrow/ids-arg-named.sql

blob: 984669d72ac038fc160fd27ec7a1fefa4671a7f4 (plain)

WITH ids(id, sort) AS (
  VALUES ('foo', 1), ('bar', 2), ('baz', 3)
)

SELECT id
  FROM ids
 WHERE id = :q
 ORDER BY sort;