On 12/24/2018 01:43 AM, Balaji Ramanathan wrote:
Hi,Are window functions enabled by default in the sqlite command line shell program that is available for download on the sqlite website? I get the error message "no such function: rownumber()" when I try to use that window function.
They are in 3.26.0. Try "row_number", with an underscore. Or, if that's not the problem, please post the failing SQL statement.
Thanks, Dan. The documentation only mentions that window functions
were added in version 3.25.0, and does not give any indication as to whether they are enabled or disabled in the command line tool. Is there perhaps a pragma setting I have to turn on for window functions to work? Thank you. Balaji Ramanathan _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
