"
SELECT 1, 2, 3 INTO vara, varb AS varc".
1. like "SELECT 1, 2, 3 INTO a, b"
Query result is "1, 2, 3", target is "a, b". The problem is that the query's
result columns don't match the structure of the target.
2. like "SELECT 1, 2, 3 INTO a, b, c AS x"
This SQL is equivalent to "SELECT 1, 2, 3 AS x INTO a, b, c".
There are other equivalent SQLs sush as
"SELECT INTO a, b, c 1, 2, 3 AS x",
"SELECT 1, 2, INTO a, b, c 3 AS x" and
"SELECT 1, INTO a, b, c 2, 3 AS x".
This is in conformity with document.
Thanks,
Wei Congrui