[sqlite] Enhance the SELECT statement?

2015-08-17 Thread Kees Nuyt
On Mon, 17 Aug 2015 20:08:23 +0200, "R.Smith" wrote: > CORRECTION: It seems one of the two options I've mentioned earlier, > namely the CREATE TABLE AS SELECT... does not actually work on the back > of a WITH clause. The other option still do, but this request has more > appeal now. CREATE

[sqlite] Enhance the SELECT statement?

2015-08-17 Thread R.Smith
On 2015-08-17 08:15 PM, Petite Abeille wrote: >> On Aug 17, 2015, at 8:08 PM, R.Smith wrote: >> >> CORRECTION: It seems one of the two options I've mentioned earlier, namely >> the CREATE TABLE AS SELECT... does not actually work on the back of a WITH >> clause. The other option still do, but

[sqlite] Enhance the SELECT statement?

2015-08-17 Thread Petite Abeille
> On Aug 17, 2015, at 8:08 PM, R.Smith wrote: > > CORRECTION: It seems one of the two options I've mentioned earlier, namely > the CREATE TABLE AS SELECT... does not actually work on the back of a WITH > clause. The other option still do, but this request has more appeal now. Hmmm?!? create

[sqlite] Enhance the SELECT statement?

2015-08-17 Thread R.Smith
CORRECTION: It seems one of the two options I've mentioned earlier, namely the CREATE TABLE AS SELECT... does not actually work on the back of a WITH clause. The other option still do, but this request has more appeal now. On 2015-08-17 07:24 PM, R.Smith wrote: > > > On 2015-08-17 05:44 PM,

[sqlite] Enhance the SELECT statement?

2015-08-17 Thread Petite Abeille
> On Aug 17, 2015, at 5:44 PM, John McKown > wrote: > > One thing that would be really useful for me in SQLite3 which is in > PostgreSQL is the INTO phrase. CTAS? AKA 'create table as'?

[sqlite] Enhance the SELECT statement?

2015-08-17 Thread R.Smith
On 2015-08-17 05:44 PM, John McKown wrote: > I use both SQLite3 and PostgreSQL. One thing that would be really useful > for me in SQLite3 which is in PostgreSQL is the INTO phrase. The PostgreSQL > documentation this is here: > http://www.postgresql.org/docs/9.4/interactive/sql-selectinto.html

[sqlite] Enhance the SELECT statement?

2015-08-17 Thread sqlite-mail
Hello ! The query you mention is not the same as: INSERT INTO table_of_intergers SELECT seqno FROM generate ORDER BY seqno; Cheers ! > Mon Aug 17 2015 17:44:58 CEST from "John McKown" > Subject: [sqlite] Enhance the SELECT >statement? > > I use both SQLite3

[sqlite] Enhance the SELECT statement?

2015-08-17 Thread Darren Duncan
On 2015-08-17 11:29 AM, John McKown wrote: > ?WONDERFUL! That just never entered my poor head. I guess that I was too > used to the way I do it in PostgreSQL. The way things are going for me > today, I feel that I'm in the lead role of "Moron Monday".? You know, PostgreSQL supports the same

[sqlite] Enhance the SELECT statement?

2015-08-17 Thread John McKown
On Mon, Aug 17, 2015 at 1:15 PM, Petite Abeille wrote: > > > On Aug 17, 2015, at 8:08 PM, R.Smith wrote: > > > > CORRECTION: It seems one of the two options I've mentioned earlier, > namely the CREATE TABLE AS SELECT... does not actually work on the back of > a WITH clause. The other option

[sqlite] Enhance the SELECT statement?

2015-08-17 Thread John McKown
ad_ to do a SELECT startement, not an INSERT INTO. I finally had some time to test and this works. ? > > Cheers ! > > Mon Aug 17 2015 17:44:58 CEST from "John McKown" > > Subject: [sqlite] Enhance the SELECT > >statement? > > > > I use both SQLite3

[sqlite] Enhance the SELECT statement?

2015-08-17 Thread John McKown
I use both SQLite3 and PostgreSQL. One thing that would be really useful for me in SQLite3 which is in PostgreSQL is the INTO phrase. The PostgreSQL documentation this is here: http://www.postgresql.org/docs/9.4/interactive/sql-selectinto.html The main reason that I could use this would be in