SELECT wat FROM sql

from blog Scattered Thoughts, | ↗ original
Working on a postgres-compatible query compiler has taught me many things. Things I was better off not knowing. Let's begin: jamie=# create table nums(a int primary key, b text); CREATE TABLE jamie=# insert into nums(a,b) values (0, 'foo'), (1, 'foo'), (2, 'foo'), (3, 'bar'); INSERT 0 4 jamie=# select a+1 from nums group by a+1; ...