Re: CREATE TABLE AS standard?

> I know I use that version my self a lot more than the SELECT INTO
> version. We probably got it 'free' from the CREATE VIEW semantics,
> as Tom suggested. I tend to use it to 'materialize' a new table when
> I'm altering schema (either denormalizing, or normalizing) and need to
> convert the type of a column. It's a little handier than seperate CREATE
> TABLE and INSERT INTO statements, although it's sematically equivalent.

I implemented CREATE TABLE AS as a semantically clearer version of
SELECT/INTO, which was (afaik) in the original Postgres95 and probably
earlier.

They are equivalent. btw, I assume that Tom used the term "abuse" in
the supportive sense of the word? :)

- Thomas

--
Thomas Lockhart lockhart(at)alumni(dot)caltech(dot)edu
South Pasadena, California