Fresh eyeballs needed: input into error

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Fresh eyeballs needed: input into error
Date: 2022-04-26 21:31:36
Message-ID: 457ef4b-792a-9ef-5172-972617d10f7@appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm getting a syntax error with an input into statement and I cannot see the
cause.

A MWE and the result (N.B.: line one wrapped for readability; it ends with
'values'):
insert into people (person_nbr,lname,fname,job_title,company_nbr,loc_nbr,
loc_phone_ext,direct_phone,direct_fax,cell_phone,email,active,comment) values
(6000,'No','Name',null,404,1,null,null,null,null,null,null,null);

2: ERROR: syntax error at end of input
LINE 2: (
^
What do I keep missing?

TIA,

Rich

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2022-04-26 21:36:10 Re: Fresh eyeballs needed: input into error
Previous Message David G. Johnston 2022-04-26 20:34:08 Re: row level security on conflict do update