Re: [sqlite] Recursive query

I confirm your query determining the fully expanded list of A_ids works as I explicitly tried it. Now. I have actually simplified the problem before presenting it here in the list. But I just tried to extrapolate the solution back to the original problem and failed miserably :-( Yes, that

Re: [sqlite] Recursive query

is not null; -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of MM Sent: Friday, June 15, 2018 2:03 PM To: SQLite mailing list; ryansmit...@gmail.com Subject: Re: [sqlite] Recursive query > > On 2018/06/15 3:19 PM, MM wrote: > I h

Re: [sqlite] Recursive query

> > On 2018/06/15 3:19 PM, MM wrote: > I have table A of rows with column "object_id", and 2 NULL columns A_id > and B_id. > Each row of A (among rows with the same object_id) either references > table A itself or table B, ie columns A_id and B_id are mutually > exclusive. > e.g. > Table A >

Re: [sqlite] Recursive query

On 2018/06/15 3:19 PM, MM wrote: I have table A of rows with column "object_id", and 2 NULL columns A_id and B_id. Each row of A (among rows with the same object_id) either references table A itself or table B, ie columns A_id and B_id are mutually exclusive. e.g. Table A object_id A_id

Re: [sqlite] Recursive query

Something like this? Your seed number will go into the values statement at the start. with recursive foo (A_id) as ( values (1) union select A.A_id from foo inner join A on foo.A_id = A.object_id where A.A_id is not null ) select distinct B.data from foo inner join A on

Re: [sqlite] Recursive query?

On Jan 12, 2014, at 11:02 AM, Darren Duncan wrote: > I would expect so; you can't have WITH RECURSIVE without WITH. It’s taking shape: http://www.sqlite.org/src/timeline?r=common-table-expr Oh, so, exciting! :) ___

Re: [sqlite] Recursive query?

On 1/11/2014, 7:33 AM, Petite Abeille wrote: On Jan 10, 2014, at 4:34 PM, Richard Hipp wrote: FYI: The sponsor is now indicating that they want to go with WITH RECURSIVE. So the CONNECT BY branch has been closed and we are starting to work on a WITH RECURSIVE

Re: [sqlite] Recursive query?

On Jan 10, 2014, at 4:34 PM, Richard Hipp wrote: > FYI: The sponsor is now indicating that they want to go with WITH > RECURSIVE. So the CONNECT BY branch has been closed and we are starting to > work on a WITH RECURSIVE implementation. Much excellent. And much thanks to

Re: [sqlite] Recursive query?

On 10.01.2014 17:34, Richard Hipp wrote: On Wed, Jan 8, 2014 at 2:35 PM, Richard Hipp wrote: FYI: The sponsor is now indicating that they want to go with WITH RECURSIVE. So the CONNECT BY branch has been closed and we are starting to work on a WITH RECURSIVE

Re: [sqlite] Recursive query?

> That's great news! This will be a serious step up in feature set for SQLite, both in ease of use and power, I look forward to it. -- Darren Duncan It will be available in the SQLite Gold edition for $10,000. {jk} ___ sqlite-users mailing list

Re: [sqlite] Recursive query?

On 1/10/2014, 7:34 AM, Richard Hipp wrote: On Wed, Jan 8, 2014 at 2:35 PM, Richard Hipp wrote: The sponsor might have a big pile of preexisting Oracle10g CONNECT BY code that they need to run. I feel sure that if they just want "recursive queries" for use in code that has not

Re: [sqlite] Recursive query?

This is really great news ! Will it be developped also for SQLite 4 ? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Recursive query?

On Wed, Jan 8, 2014 at 2:35 PM, Richard Hipp wrote: > > > The sponsor might have a big pile of preexisting Oracle10g CONNECT BY code > that they need to run. I feel sure that if they just want "recursive > queries" for use in code that has not yet been written then we can

Re: [sqlite] Recursive query?

On Wed, Jan 8, 2014 at 2:28 PM, Petite Abeille wrote: > Aha… I see… well… if that mysterious sponsor is familiar with ‘connect by’ > they should have no issue with a recursive ‘with’ clause syntax, which is > what Oracle provides now. > The sponsor might have a big pile

Re: [sqlite] Recursive query?

Aha… I see… well… if that mysterious sponsor is familiar with ‘connect by’ they should have no issue with a recursive ‘with’ clause syntax, which is what Oracle provides now. See "Recursive Subquery Factoring” in Oracle’s very own documentation:

Re: [sqlite] Recursive query?

That branch is a "sponsored" change. We are in communication with the sponsor asking if they will consider WITH RECURSIVE syntax. Their original request specified Oracle10g-compatible CONNECT-BY syntax. It depends on what the sponsor really wants. (We await their reply.) The code will only

Re: [sqlite] Recursive Query

Alexander Yap <[EMAIL PROTECTED]> writes: > > Hi All, > I just want to know if WITH RECURSIVE query is supported by SQLite. > > Thanks in advance. > > Regards, > > Alex http://www.sqlite.org/lang_select.html MikeW ___ sqlite-users mailing list