Обсуждение: Re: [HACKERS] INSERT INTO
Is this done? > The pages at http://postgresql.nextpath.com/docs/user/sql-select.htm and > http://postgresql.nextpath.com/docs/user/sql-insert.htm imply that SELECT > INTO and INSERT INTO <table> SELECT <query> will work with existing > tables but in fact it always creates the table and issues an error if > they already exist. What needs to be fixed here? The code or the docs? > > -- > 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
Thus spake Bruce Momjian > Is this done? > > The pages at http://postgresql.nextpath.com/docs/user/sql-select.htm and > > http://postgresql.nextpath.com/docs/user/sql-insert.htm imply that SELECT > > INTO and INSERT INTO <table> SELECT <query> will work with existing > > tables but in fact it always creates the table and issues an error if > > they already exist. What needs to be fixed here? The code or the docs? I posted the correction. I think Tom Lane is putting it into the docs. -- 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.
> I posted the correction. I think Tom Lane is putting it into the docs. Actually, the other tgl has some patches :) - Thomas -- Thomas Lockhart lockhart@alumni.caltech.edu South Pasadena, California
"D'Arcy" "J.M." Cain <darcy@druid.net> writes: > I posted the correction. I think Tom Lane is putting it into the docs. Not me --- Lockhart. I know it's confusing having two guys with the initials tgl on the same project ;-). regards, tom lane
Thus spake Tom Lane > "D'Arcy" "J.M." Cain <darcy@druid.net> writes: > > I posted the correction. I think Tom Lane is putting it into the docs. > > Not me --- Lockhart. > > I know it's confusing having two guys with the initials tgl on the > same project ;-). Sheesh! We'll just have to get together somewhere all together for a beer and straighten all this out. :-) -- 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.