Yes, CTEs are awesome. Especially when you don’t force materialization and the optimizer can work its magic.
I’ve had a lot of fun with window functions as well.
Yes, CTEs are awesome. Especially when you don’t force materialization and the optimizer can work its magic.
I’ve had a lot of fun with window functions as well.
Um, actually… A signed 32-bit counter would loop back to December 1901, so the calendar is presumably 31-bit unsigned. (Sorry)
There’s always the classic C strcpy :)
char *strcpy(char *dest, char *src) {
char *p = dest;
while (*p++ = *src++);
return dest;
}
TDD
const max12 = (x, y) => { if (x === 1 && y === 2) { return 2; } else if (x === 7 && y === 4) { return 7; } else { return x; } };