Re: [sqlite] equivalent for JOIN LATERAL

2015-02-09 Thread Dominique Devienne
On Mon, Feb 9, 2015 at 6:12 AM, James K. Lowden wrote: > > If not, would it be possible too much effort ? > > I'm guessing the answer is No because the prerequisites are missing. > [DD] And that's the crux of it. SQLite has virtual tables, and as such can approximate

Re: [sqlite] equivalent for JOIN LATERAL

2015-02-08 Thread Darren Duncan
I recall that http://blog.heapanalytics.com/postgresqls-powerful-new-join-type-lateral/ shows how Pg 9.3's LATERAL join is useful in practice, as it lets you do in declarational SQL what you may have needed procedural code for before, in which case it is an improvement. -- Darren Duncan On

Re: [sqlite] equivalent for JOIN LATERAL

2015-02-08 Thread Big Stone
oups ! Thank you Roger, I had forgot to post the link. I got it via a tweet of Wes McKinney, one of the DataScience leader in the Python World. https://twitter.com/wesmckinn/status/564526251591733248 ___ sqlite-users mailing list

Re: [sqlite] equivalent for JOIN LATERAL

2015-02-08 Thread James K. Lowden
On Sun, 8 Feb 2015 23:52:43 +0100 Big Stone wrote: > I fall over this presentation of LATERAL, from postgresql guys. > > Does it exist in SQLITE ? Syntactically, no. Functionally, in part. > If not, would it be possible too much effort ? I'm guessing the answer is No

Re: [sqlite] equivalent for JOIN LATERAL

2015-02-08 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/08/2015 03:32 PM, Simon Slavin wrote: > For those like me who hadn't heard of it, here's a reference: Here is a presentation referenced "Modern SQL in PostgreSQL", with title "Still using Windows 3.1? So why stick to SQL-92?" Lots of nice

Re: [sqlite] equivalent for JOIN LATERAL

2015-02-08 Thread Simon Slavin
On 8 Feb 2015, at 10:52pm, Big Stone wrote: > I fall over this presentation of LATERAL, from postgresql guys. > (look at pages 1 to 16) For those like me who hadn't heard of it, here's a reference:

Re: [sqlite] equivalent for JOIN LATERAL

2015-02-08 Thread Big Stone
If not, would it be possible "without" too much effort ? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] equivalent for JOIN LATERAL

2015-02-08 Thread Big Stone
Hello, I fall over this presentation of LATERAL, from postgresql guys. (look at pages 1 to 16) Does it exist in SQLITE ? If not, would it be possible too much effort ? ___ sqlite-users mailing list sqlite-users@sqlite.org