Re: [sqlite] cnt(x) what do the brackets signify

2014-11-12 Thread Paul Sanderson
Thanks Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite http://sandersonforensics.com/forum/content.php?168-Reconnoitre - VSC processing made

Re: [sqlite] cnt(x) what do the brackets signify

2014-11-12 Thread Igor Tandetnik
On 11/12/2014 12:52 PM, Paul Sanderson wrote: I have googled but can't see what cnt(x) actually signifies - cnt is not a function The same thing it signifies in "CREATE TABLE cnt(x);" "cnt" is an "ephemeral" table with a single column named "x". -- Igor Tandetnik

Re: [sqlite] cnt(x) what do the brackets signify

2014-11-12 Thread Stephan Beal
On Wed, Nov 12, 2014 at 6:52 PM, Paul Sanderson < sandersonforens...@gmail.com> wrote: > I have googled but can't see what cnt(x) actually signifies - cnt is > not a function - could someone point me to a resource so I can > understand this construct > The diagram at the top of this page

[sqlite] cnt(x) what do the brackets signify

2014-11-12 Thread Paul Sanderson
I am looking at recursive cte and saw this example I have googled but can't see what cnt(x) actually signifies - cnt is not a function - could someone point me to a resource so I can understand this construct Thanks WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE