ids-arg-pos.sql « query « 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/query/ids-arg-pos.sql

blob: a13888e2fd7b7164530f375c1e94f75a229d275e (plain)

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

SELECT id
  FROM ids
 WHERE id = ?
 ORDER BY sort;