On Thu, Sep 22, 2016 at 9:43 PM, Darren Duncan <dar...@darrenduncan.net> wrote:
> On 2016-09-22 12:16 PM, Petite Abeille wrote: > >> >> On Sep 22, 2016, at 9:04 PM, Richard Hipp <d...@sqlite.org> wrote: >>> >>> (https://www.sqlite.org/draft/releaselog/3_15_0.html). >>> >> >> Ohhhhh! Row Values! Nice! :) >> >> https://www.sqlite.org/draft/rowvalue.html >> > > I second that, its a valuable feature to have. > For those interested, I ran by chance on this article that might have been the origin of row values in SQLite: From http://use-the-index-luke.com/blog/2014-05/what-i-learned-about-sqlite-at-a-postgresql-conference : > We also discussed whether or not SQLite can cope with search conditions > like(col1, col2) < (val1, val2)—it can’t. > Here Richard was questioning the motivation to have that, so I gave him an > elevator-pitch version of my > “Pagination Done The PostgreSQL Way” talk. I think he got “excited” about > this concept to avoid offset > at all and I’m curious to see if he can make it work in SQLite faster than > I’m adding SQLite content to Use The Index, Luke:) That was 2 years ago :).--DD PS: “Pagination Done The PostgreSQL Way” talk: http://use-the-index-luke.com/blog/2013-07/pagination-done-the-postgresql-way http://www.slideshare.net/MarkusWinand/p2d2-pagination-done-the-postgresql-way _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
