insert ..... returning problem

2021-06-24 Thread Michael Ivanov
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 p1515544c0001 AS insert into

Re: insert ..... returning problem

2021-06-24 Thread Michael Ivanov
Hallo, no. I am using postgres c library, namely I'm calling PQexec() Best regards, On 24.06.2021 16:14, Laurenz Albe wrote: > On Thu, 2021-06-24 at 12:31 +0300, Michael Ivanov wrote: >> I'm trying to insert a record returning column value using the following >> qu

Re: insert ..... returning problem

2021-06-24 Thread Michael Ivanov
r clarification! On 24.06.2021 17:13, Laurenz Albe wrote: > On Thu, 2021-06-24 at 16:25 +0300, Michael Ivanov wrote: >>>> I'm trying to insert a record returning column value using the following >>>> query: >>>> >>>>INSERT INTO t_loa