insert ..... returning problem
От | Michael Ivanov |
---|---|
Тема | insert ..... returning |
Дата | |
Msg-id | dc22ae8e-e75e-2e2a-8e93-fe9c79de0c91@logit-ag.de обсуждение исходный текст |
Ответы |
Re: insert ..... returning |
Список | pgsql-general |
Greetings! I'm trying to insert a record returning column value using the following query: INSERT INTO t_load (load_id, load_type) VALUES (:id, :typ) returning load_idx INTO :idx But when I try to prepare the query I'm getting the following error: PREPARE p1515544c00000001 AS insert into t_load (load_id, load_type) values ($1, $2) returning load_idx into $3]: ERROR: syntax error at or near "into" LINE 1: ...ad_id, load_type) values ($1, $2) returning load_idx into $3 ^ Why 'into var' is not accepted here? Best regards, -- \ / | | (OvO) | Mikhail Iwanow | (^^^) | Voice: +7 (911) 223-1300 | \^/ | E-mail: ivans@logit-ag.de | ^ ^ | |
В списке pgsql-general по дате отправления: