aboutsummaryrefslogtreecommitdiff
path: root/dbstore/sql/test/queryrow/ids-arg-named.sql
blob: 984669d72ac038fc160fd27ec7a1fefa4671a7f4 (plain)
1
2
3
4
5
6
7
8
WITH ids(id, sort) AS (
  VALUES ('foo', 1), ('bar', 2), ('baz', 3)
)

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