> $ cat sql.ur
> table t : { X : int, Y : int }
> table s : { X : int, Y : int, Z : int }
> val test = dml (INSERT INTO t (X, Y) VALUES
> ( (SELECT s.X FROM s WHERE s.Z = 1),
> (SELECT s.Y FROM s WHERE s.Z = 1) )
> )
Hi, the first SELECT gives back a list of values so clearly it cannot
be feed to a place which expects one value. Same to the second.
- Gergely