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
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
> 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
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,
> 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'?
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
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
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
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
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
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
11 matches
Mail list logo