in_with_subquery_where.sqlx 266 B

1234567891011121314
  1. /* postgres can not */
  2. USE plato;
  3. pragma warning("error", "4501");
  4. $subq = (SELECT subkey FROM Input WHERE value = "ddd");
  5. --INSERT INTO Output
  6. SELECT
  7. key as key,
  8. "" as subkey,
  9. "value:" || value as value
  10. FROM Input
  11. WHERE subkey in ($subq)
  12. ORDER BY key