-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 19/03/16 03:30, Paul Sanderson wrote: > I know that keywords can be quoted but I am interested in just > those that can be used unquoted (even if not advisable)
Out of curiousity, why? My rule of thumb is to always quote (using square brackets) when the query is generated by code, and only quote where reasonable when the query is written by a human. For the APSW shell the following are all quoted: * zero length names (yes SQLite allows them) * if it starts with a digit * if any non-alphanumeric/underscore present (ascii only alphas ok) * if in the SQLite list of keywords Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iEYEARECAAYFAlbt2QIACgkQmOOfHg372QRhAQCfc00p/L15AJmx8Zgrr9isuU5H B3cAnim38/I6S3gNsHQ7WZtJKok+T+sY =O8pL -----END PGP SIGNATURE-----
