Postgres Pro
Downloads
Home   >   mailing lists

Re: CTAS command tags - Mailing list pgsql-hackers

From Andreas Karlsson
Subject Re: CTAS command tags
Date
Msg-id a2270a18-e61c-25d0-c8b2-c2f67f0cc274@proxel.se
Whole thread Raw
In response to Re: CTAS command tags  (Darafei "Komяpa" Praliaskouski <me@komzpa.net>)
Responses Re: CTAS command tags  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
On 1/22/21 2:19 PM, Darafei "Komяpa" Praliaskouski wrote:
> Having row count right away is very useful in CTAS in analytical and GIS 
> usage scenarios.

I can see that, but would it not work if it was:

CREATE TABLE AS 1

Disclaimer: I have not looked at the code so maybe there is some good 
reason that would not work.

Andreas

pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: Commitfest 2021-01 Now in Progress
Next
From: Tom Lane
Date:
Subject: Re: Add primary keys to system catalogs