Postgres Combine Select and insert in one Query

Question

pardon for this silly question, seems its to late to think clear.

How can I combine these two Queries in PostgreSQL to one. That "NewUserAge" gets insert into field age from query two?

SELECT max(age+1) as NewUserAge 
  FROM mytable;


INSERT INTO 
    mytable (age,name) 
VALUES
    (11,'Bert');

Thanks for your help,

tony

John Woo · Accepted Answer · 2013-03-08 17:24:39Z

2

INSERT INTO mytable (age,name) 
SELECT  max(age) + 1, 'Bert'
FROM myTable

answered Mar 8, 2013 at 17:24

John Woo

265k70 gold badges509 silver badges500 bronze badges

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

1 Answer 1