insert ..... returning problem - Mailing list pgsql-general

From Michael Ivanov
Subject insert ..... returning problem
Date
Msg-id dc22ae8e-e75e-2e2a-8e93-fe9c79de0c91@logit-ag.de
Whole thread Raw
Responses Re: insert ..... returning problem  (Laurenz Albe <laurenz.albe@cybertec.at>)
List 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 by date:

Previous
From: Thorsten Schöning
Date:
Subject: Re: [SPAM] Re: How to hash a large amount of data within Postgres?
Next
From: Vijaykumar Jain
Date:
Subject: Re: Postgres PANIC when it could not open file in pg_logical/snapshots directory