News for hackers. Stuff that matters.
Re:We Can Do Better Than SQL by tathougies on Thursday May 09, 2019 @03:50PM (#19871657)
> SELECT (SomeType, 1)

This cannot be the case if you call each thing a 'set'. Unless `(a, b)` calculates the cross product, there is no meaningful non-arbitrary way to assign each element of a to an element of b. That would depend on an ordering, which makes it not a set to everyone but a marketing dept somewhere.

Re:We Can Do Better Than SQL by RedCrowbar on Thursday May 09, 2019 @03:57PM (#19871744)
`(a, b)` is a cross-product, just like "SELECT * FROM a, b"
Re:We Can Do Better Than SQL by thwd on Thursday May 09, 2019 @04:08PM (#19871864)
They're saying that both of those expressions are valid, not equivalent.

SELECT count(star) FROM table

and

SELECT star FROM table

Are both valid, not equivalent.

Furthermore, listing any kind of set depends on some ordering, be it random.