Re: [HACKERS] INSERT INTO - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] INSERT INTO
Date
Msg-id 199905101819.OAA04407@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] INSERT INTO  ("D'Arcy" "J.M." Cain <darcy@druid.net>)
List pgsql-hackers
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,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: [HACKERS] views and group by (formerly: create view as selec
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Minor pg_dump buglet