On Fri, Feb 16, 2018 at 1:11 PM, x <[email protected]> wrote:
> Thanks for the replies. For my purpose it was about avoiding the
> possibility of having to apply a limit to a query that might already have a
> limit clause.
Good point. I tried, and indeed that's an issue. I really really which
SQLite expose more meta-data about prepared statements :). --DD
C:\Users\ddevienne>sqlite3
SQLite version 3.21.0 2017-10-24 18:55:49
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite>
sqlite> create table t (c);
sqlite> insert into t values (1), (2), ('three');
sqlite> select * from t;
1
2
three
sqlite> select * from t limit 1;
1
sqlite> select * from t limit 1 limit 2;
Error: near "limit": syntax error
sqlite>
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
