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 easy



On 12 November 2014 18:00, Igor Tandetnik  wrote:
> 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
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


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

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


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 demonstrates what it is:

http://www.sqlite.org/lang_with.html


-- 
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[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 x<100)
SELECT x FROM cnt;
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users