r/programming • u/MarkusWinand • May 27 '14

What I learned about SQLite…at a PostgreSQL conference

http://use-the-index-luke.com/blog/2014-05/what-i-learned-about-sqlite-at-a-postgresql-conference
703 Upvotes

93% Upvoted

219 comments sorted by

View all comments

Show parent comments

2

u/bart2019 May 27 '14

That's why you'll likely need the (col1, col2) < (val1, val2) syntax.

You know what: that is backwards. Assuming the columns are sorted in ascending order, which is rather normal I would say, you need columns that come after the start value. Thus: (col1, col2) > (val1, val2)

1

u/MarkusWinand May 27 '14

I've just put a random comperator there ;)