4 ms·
Isn't SQL a standard? I know Access and SQLite are a bit quirky, but for all the big stuff I stick to the ANSI SQL standard. Well, I did, until I moved to a Li
by mahmud 18y ago
Isn't SQL a standard? I know Access and SQLite are a bit quirky, but for all the big stuff I stick to the ANSI SQL standard.
Well, I did, until I moved to a Lisp object store :-P
- thristian 18y agoSQL is a standard with approximately zero fully-compliant implementations. What's more, every database has a variety of features that aren't covered by the SQL spec, or use different syntax for some feature for historical reasons. I've got a lot of respect for the PostgreSQL devs for occasionally breaking backwards-compatibility in the name of ANSI-SQL compliance, and for clearly marking deviations from ANSI-SQL in their reference documentation.