Re: [HACKERS] insert with multiple targetLists

2002-06-01 Thread Bruce Momjian
Rod Taylor wrote: > > INSERT INTO t1 (c1) VALUES (1), (2); > > > > would be executed in a similar fashion to: > > > > INSERT INTO t1 (c1) VALUES (1); > > INSERT INTO t1 (c1) VALUES (2); > > > > Does this sound reasonable? Sounds good to me. > I debated doing the above too. In f

Re: [HACKERS] insert with multiple targetLists

2002-05-01 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > I've been taking a look at fixing the TODO item: > o Allow INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..) > My first plan of attack was to replace the current list of ResTargets > in InsertStmt with a list of lists. If you look at the SQL sp

Re: [HACKERS] insert with multiple targetLists

2002-05-01 Thread Rod Taylor
> INSERT INTO t1 (c1) VALUES (1), (2); > > would be executed in a similar fashion to: > > INSERT INTO t1 (c1) VALUES (1); > INSERT INTO t1 (c1) VALUES (2); > > Does this sound reasonable? I debated doing the above too. In fact, I had a partial implementation at one point. Howeve

[HACKERS] insert with multiple targetLists

2002-05-01 Thread Neil Conway
Hi all, I've been taking a look at fixing the TODO item: o Allow INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..) My first plan of attack was to replace the current list of ResTargets in InsertStmt with a list of lists. The problem with that approach is that: (a) the InsertStmt