News for hackers. Stuff that matters.

A comment on Select * from cloud. Parent comment

Re:Select * from cloud by netule on Friday September 30, 2022 @01:02PM (#33037439)
It's also the simplest use case of INSERT imaginable and fails to be applicable with a slightly more complex one:

  INSERT INTO table1 (col_1, col_2, col3)
  SELECT COUNT(col_6), col_4, col_5 FROM table2 INNER JOIN...
[ Parent | on HN ]
Re:Select * from cloud by dllthomas on Friday September 30, 2022 @01:31PM (#33037916)
I think in principle we could allow

    INSERT INTO table1
        col_1 = COUNT(table2.col_6),
        col_2 = table2.col_4,
        col3 = table2.col_5
    FROM table2 INNER JOIN ...
[ Parent | on HN ]