It must be the first day back after Xmas

[NogDog]

A co-worker asked me to look at a PostgreSQL query that was throwing a SQL syntax error. The error message claimed the problem was near "SORT", in a query that looked something like:

SELECT * FROM table_name WHERE something IN('v1', 'v2') SORT BY some_column

We looked at it together for several minutes, trying a few variations and commenting some things out, until the light finally went off in my brain and I realized it was supposed to be "ORDER BY". :o

[dalecosp]

Hmm, so ... I guess I'm glad my employer gives us all two days off each Christmas. 😃

However, I'll be on the lookout for syntax errors tomorrow, starting at 8 o'clock, per the usual ... 🙂

[Derokorian]

Ha my office is closed this whole week, paid holidays too, no need to take vacation!