PostgreSQL: Combine Select and Insert with returning ID

Question

Lets say I have a table temp123 as

Column      |      Type         |       Modifiers
------------+-------------------+------------------------
id          | integer           | not null default nextval('temp12_id_seq'::regclass)
description | character varying |

I would like to combine the ID returned by

INSERT INTO temp123 (description) 
      VALUES ('TESTING') RETURNING ID;

with a `SELECT'. For example (doesn't work):

SELECT 23, x.* 
FROM (INSERT INTO temp123 (description) 
       VALUES ('TESTING') RETURNING id ) AS x;

PostgreSQL v9.0.2

Daniel Vérité · Accepted Answer · 2012-08-28 10:04:25Z

4

The SELECT part is not needed in your example. The desired result would be obtained like this with any PG version that supports INSERT...RETURNING (>=8.2):

insert into temp123(description) values('TESTING') returning 23,*;

answered Aug 28, 2012 at 10:04

Daniel Vérité

62.3k16 gold badges134 silver badges160 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL: Combine Select and Insert with returning ID

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related