3 ms·
> This is perfectly valid SQL no, it's not. this query only runs because postgres is not compliant with SQL-99 T301. the query is unambiguously invalid under S
by gfody 6y ago
> This is perfectly valid SQL
no, it's not. this query only runs because postgres is not compliant with SQL-99 T301. the query is unambiguously invalid under SQL-92.
> When using offensive language
fwiw I regret my tone but this article deserves to be criticized. I love and respect rdbms technology and it's exciting to see anything "SQL" in a headline on HN - but then it bums me out to see bogus terms tossed around and insane queries presented as normal. if this were some beginner blog writing about lessons learned that's one thing, but this is a professional consultancy firm writing with the air of "you can trust us, we're experts".