News for hackers. Stuff that matters.
Re:We Can Do Better Than SQL by dragonwriter on Thursday May 09, 2019 @05:40PM (#19872705)
It's only a slight misstatement; scalar queries are a subset of table queries in SQL, rather than different thing, but scalar queries are allowed in places where other table queries are not.

The difference in EdgeDB isn't really everything returns a set, but seems instead to be that everything consumes sets and not just scalars.

Re:We Can Do Better Than SQL by vpetrovykh on Thursday May 09, 2019 @07:54PM (#19873707)
You are exactly right about everything consuming sets in EdgeDB. Even when a function is defined on scalars, it's really defined on singleton sets. Literals are also singleton sets, so "1" and "{1}" are equivalent and so are "foo(1)" and "foo({1})". Usually we omit the set braces for singleton values to reduce visual noise.