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(at){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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026