Is there a summary of the “minor” dialect differences between GSQL and SQL to help the noob?
I find that my SQL habits are getting me into trouble.
So far I have stumbled on:
- use
==
(as in C++) instead of=
like many/most SQL - use
!=
(as in C++) instead of<>
like many/most SQL - use double quotes
"
(as in C++) instead of'
like many/most SQL - can’t optionally use
VERTEXTYPE.name
, must only usename
, unlike SQLTABLENAME.name
(wherename
is a column name/attribute.)
(I started with C, so SQL’s syntax at first annoyed me, but I made the effort to deal with it. Sometimes I still goof when writing Python/C vs. SQL. So, having to deal with these dialect differences between GSQL and SQL is an unwelcome cognitive load while trying to learn GSQL.)