insert ..... returning problem

Поиск
Список
Период
Сортировка
От Michael Ivanov
Тема insert ..... returning problem
Дата
Msg-id dc22ae8e-e75e-2e2a-8e93-fe9c79de0c91@logit-ag.de
обсуждение исходный текст
Ответы Re: insert ..... returning problem  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список 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 по дате отправления:

Предыдущее
От: Thorsten Schöning
Дата:
Сообщение: Re: [SPAM] Re: How to hash a large amount of data within Postgres?
Следующее
От: Vijaykumar Jain
Дата:
Сообщение: Re: Postgres PANIC when it could not open file in pg_logical/snapshots directory