[sqlite] Can't create LEFT or RIGHT functions with sqlite3_create_function()

2016-02-08 Thread Eric Hill
-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Monday, February 08, 2016 3:39 PM To: SQLite mailing list Subject: Re: [sqlite] Can't create LEFT or RIGHT functions with sqlite3_create_function() On 2/8/16, Eric Hill wrote: > Hey, > > It appears that LEFT and RIGHT are treated a

[sqlite] Can't create LEFT or RIGHT functions with sqlite3_create_function()

2016-02-08 Thread Eric Hill
Hey, It appears that LEFT and RIGHT are treated as reserved words by SQLite, so my attempts to use sqlite3_create_function() to create my own LEFT and RIGHT SQL functions have been unsuccessful (I'm using 3.8.11.1). Several databases (SQL Server, MySQL) define their own LEFT and RIGHT function

[sqlite] Can't create LEFT or RIGHT functions with sqlite3_create_function()

2016-02-08 Thread Richard Hipp
On 2/8/16, Eric Hill wrote: > Hey, > > It appears that LEFT and RIGHT are treated as reserved words by SQLite, so > my attempts to use sqlite3_create_function() to create my own LEFT and RIGHT > SQL functions have been unsuccessful (I'm using 3.8.11.1). Several > databases (SQL Server, MySQL) def