ERROR: malformed record literal: "",DETAIL: Missing left parenthesis?
От | Emi Lu |
---|---|
Тема | ERROR: malformed record literal: "",DETAIL: Missing left parenthesis? |
Дата | |
Msg-id | 4E1484F7.5080800@encs.concordia.ca обсуждение исходный текст |
Ответы |
Re: ERROR: malformed record literal: "",DETAIL: Missing left
parenthesis?
|
Список | pgsql-sql |
Good morning, A question about: ERROR: malformed record literal: "" DETAIL: Missing left parenthesis. Can someone tell me what cause the error? ======================== Table z_drop; Column | Type -------------+------------------------ run_date | character varying(128) adm_year | character varying(4) adm_sess | character varying(1) faculty | character varying(128) ac_cycle | character varying(128) deg_code | charactervarying(128) discipline | character varying(128) thesis | character varying(128) elig_stype | character varying(128)stud_source | character varying(128) applied | numeric reviewed | numeric accepted | numeric confirmed | numeric registered | numeric hold | numeric forward | numeric refused | numeric cancelled | numeric other | numeric pending | numeric PREPARE test(z_drop) AS INSERT INTO z_drop VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21) ; EXECUTE test('', '1', '1', '1', '1', '1', '1', '1', '1', '', 1, 1, '1', '0', '0', '0', '0', '0', '0', '0', '0') ; Thank you, Emi
В списке pgsql-sql по дате отправления: