--- Aladdin Lampé <[EMAIL PROTECTED]> wrote: > 1. How can I change the SQL concatenation operator '||' to '..' in order to > have a better > integration with the Lua programming language?
Just curious... since SQL is not remotely similar to Lua in syntax or behavior, how would changing the SQL concat operator help with Lua integration? > 3. May this modification introduce parse errors I can't even imagine right > now? The concat operator is ingrained in SQL and SQLite in particular: $ grep '".*||.*"' *.c alter.c: "'sqlite_autoindex_' || %Q || substr(name,%d+18,10) " alter.c: "sql = substr(sql,1,%d) || ', ' || %Q || substr(sql,%d,length(sql)) " vacuum.c: "SELECT 'CREATE TABLE vacuum_db.' || substr(sql,14,100000000) " vacuum.c: "SELECT 'CREATE INDEX vacuum_db.' || substr(sql,14,100000000)" vacuum.c: "SELECT 'CREATE UNIQUE INDEX vacuum_db.' || substr(sql,21,100000000) " ...etc... I can see a case for embedding an SQL-like syntax into the Lua language, similar to what C# does: http://msdn2.microsoft.com/en-us/library/bb308959.aspx But that would be a very ambitious non-trivial integration project. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
