back

by sensanaty·2y ago·view on hn ↗
It's been a while since I've touched SQP, and most of my experience is with psql, but as far as I can recall if you type commands into the psql console without a semicolon the commands don't get executed properly?

Still a dumb reason to deduct points though

1 comments
You are correct, on the command line you need it but pretty much every GUI tool and language binding auto-add it for you. It felt very nit-picky and not at all based in reality. I got all the joins/limits/order/where/etc correct, the semicolon doesn’t matter for what I felt the test should be actually testing on. Testing human’s ability to memorize or write perfect syntax when they will never do that unaided in reality is just silly.