Select * from cloud

Re:Select * from cloud by wyager on Friday September 30, 2022 @12:51PM (#33037264)

I have plenty of beef with SQL, but your insert versus update example doesn't make sense to me. That's a perfectly reasonable difference; insert is always a dense operation while update is usually a sparse operation.

[ Parent | on HN ]

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 ]