Hi,
Using the sqlite-tools-linux-x86-3250100 Linux binaries I find that
Window functions in VIEWS behave differently from PostgreSQL 9.6 and
from what I expect.
DROP TABLE IF EXISTS example;
CREATE TABLE example(t INT, total INT);
INSERT INTO example VALUES(0,2);
INSERT INTO example VALUES(5,1);
INSERT INTO example VALUES(10,1);
DROP VIEW IF EXISTS view_example;
CREATE VIEW view_example AS
SELECT
NTILE(256) OVER (ORDER BY total) - 1 AS nt
FROM
example
;
SELECT * FROM view_example;
In SQLite 3.25.1 I get 0, 0, 0, while PostgreSQL 9.6 gives 0, 1, 2.
Thanks,
--
https://bjoern.hoehrmann.de/
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
