B V, Phanisekhar <[EMAIL PROTECTED]> wrote:
select * from tableName order by someField DESC
limit ROUND( (select count(*) from tableName) / 10);
"limit_opt ::=",
"limit_opt ::= LIMIT expr",
"limit_opt ::= LIMIT expr OFFSET expr",
"limit_opt ::= LIMIT expr COMMA expr",
Which one of the above four will allow the above statement to pass
through?
The second.
I didn't find "ROUND" in parser.c file.
round() is a built-in function in SQLite - see
http://sqlite.org/lang_expr.html . I'm not familiar with the source code
to tell you where it is parsed. The whole "ROUND( (select count(*) from
tableName) / 10)" piece is parsed as "expr".
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------