Re: Multi-row insert: error at terminal row.
От | Paul Förster |
---|---|
Тема | Re: Multi-row insert: error at terminal row. |
Дата | |
Msg-id | 23EFF7D8-D708-4F5F-826C-A7FB0F7C265A@gmail.com обсуждение исходный текст |
Ответ на | Re: Multi-row insert: error at terminal row. (Rich Shepard <rshepard@appl-ecosys.com>) |
Ответы |
Re: Multi-row insert: error at terminal row.
Re: Multi-row insert: error at terminal row. |
Список | pgsql-general |
Hi Rich, > On 29. Oct, 2020, at 17:08, Rich Shepard <rshepard@appl-ecosys.com> wrote: > > On Thu, 29 Oct 2020, Paul Förster wrote: > >>> (2698,'Port of Portland','http://www.portofportland.com',null,'Port','Opportunity',null); >> the last line has a closing parenthesis missing. > > Paul, > > I see a closing parenthesis immediately in front of the semi-colon and emacs > shows it matches the opening parenthesis. I don't know Emacs, I'm a vi guy. ;-) But I guess that Emacs shows the matching closing bracket at the beginning of the line, which matches that single tuple.But you also need a closing bracket for the set of tuples like this: insert ... ( (v1, v2, v3), (v4, v5, v6), (v7, v8, v9) <= this is the bracket pair that Emacs shows as matching. ); <= this is the missing bracket. Cheers, Paul
В списке pgsql-general по дате отправления: