Thus spake Thomas Lockhart
> > I think the docs for SELECT INTO should be changed, as (if memory
> > serves) it always creates, while INSERT INTO should always require the
> > table to already exist.
> 
> I went back and tested v6.3.2 and found the same behavior. D'Arcy,
> would you have time to touch the docs? It would be in
> 
>   doc/src/sgml/ref/{insert,select}.sgml
> 
> Note that there is a separate section for SELECT INTO near the bottom
> of select.sgml.

Does this cover it?

RCS file: RCS/select.sgml,v
retrieving revision 1.1
diff -c -r1.1 select.sgml
*** select.sgml 1999/05/08 13:52:15     1.1
--- select.sgml 1999/05/08 13:56:18
***************
*** 85,92 ****
        If the INTO TABLE clause is specified, the result of the
        query will be stored in another table with the indicated
        name.
!       If <replaceable class="PARAMETER">new_table</replaceable> does
!       not exist, it will be created automatically.
        Refer to <command>SELECT INTO</command> for more information.
        <note>
         <para>
--- 85,92 ----
        If the INTO TABLE clause is specified, the result of the
        query will be stored in another table with the indicated
        name.
!       The <replaceable class="PARAMETER">new_table</replaceable> will
!       be created automatically and should not exist before this command.
        Refer to <command>SELECT INTO</command> for more information.
        <note>
         <para>

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 424 2871     (DoD#0082)    (eNTP)   |  what's for dinner.

Sat, 8 May 1999 09:58:16 -0400 (EDT)
"D'Arcy" "J.M." Cain <darcy@druid.net>
Re: [HACKERS] INSERT INTO
> Does this cover it?

Great. Thanks!

                      - Tom

-- 
Thomas Lockhart				lockhart@alumni.caltech.edu
South Pasadena, California

Sat, 08 May 1999 16:45:45 +0000
Thomas Lockhart <lockhart@alumni.caltech.edu>
Re: [HACKERS] INSERT INTO
APplied.


> Thus spake Thomas Lockhart
> > > I think the docs for SELECT INTO should be changed, as (if memory
> > > serves) it always creates, while INSERT INTO should always require the
> > > table to already exist.
> > 
> > I went back and tested v6.3.2 and found the same behavior. D'Arcy,
> > would you have time to touch the docs? It would be in
> > 
> >   doc/src/sgml/ref/{insert,select}.sgml
> > 
> > Note that there is a separate section for SELECT INTO near the bottom
> > of select.sgml.
> 
> Does this cover it?
> 
> RCS file: RCS/select.sgml,v
> retrieving revision 1.1
> diff -c -r1.1 select.sgml
> *** select.sgml 1999/05/08 13:52:15     1.1
> --- select.sgml 1999/05/08 13:56:18
> ***************
> *** 85,92 ****
>         If the INTO TABLE clause is specified, the result of the
>         query will be stored in another table with the indicated
>         name.
> !       If <replaceable class="PARAMETER">new_table</replaceable> does
> !       not exist, it will be created automatically.
>         Refer to <command>SELECT INTO</command> for more information.
>         <note>
>          <para>
> --- 85,92 ----
>         If the INTO TABLE clause is specified, the result of the
>         query will be stored in another table with the indicated
>         name.
> !       The <replaceable class="PARAMETER">new_table</replaceable> will
> !       be created automatically and should not exist before this command.
>         Refer to <command>SELECT INTO</command> for more information.
>         <note>
>          <para>
> 
> -- 
> D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
> http://www.druid.net/darcy/                |  and a sheep voting on
> +1 416 424 2871     (DoD#0082)    (eNTP)   |  what's for dinner.
> 
> 


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Mon, 10 May 1999 14:19:04 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] INSERT INTO