postgres how to insert values with 2 selects

Question

I'm trying to do a query on Postgres but it's not working. I'd like to create an insert query with 2 select:

Example :

INSERT INTO table1 (id_1, id_2)
SELECT id from table_2 where code='01',
SELECT id from table_2 where code='02';

I don't find the good syntax for this.

Basharat Ali · Accepted Answer · 2021-06-29 10:19:30Z

1

I believe below query will works for your use case

INSERT INTO stats(totalProduct, totalCustomer, totalOrder)
VALUES(
    (SELECT COUNT(*) FROM products),
    (SELECT COUNT(*) FROM customers),
    (SELECT COUNT(*) FROM orders)
);

you can changes query accordingly

answered Jun 29, 2021 at 10:19

Basharat Ali

1,22910 silver badges13 bronze badges

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

Comments

Arulkumar · Accepted Answer · 2021-06-29 13:19:53Z

0

You can add one more SELECT to achieve this

INSERT INTO table_1 (id_1, id_2)
SELECT 
    (SELECT id FROM table_2 WHERE code = '01') AS Id_1,
    (SELECT id FROM table_2 WHERE code = '02') AS Id_2;

Or you may try with CASE expression:

INSERT INTO table1 (id_1, id_2)
SELECT MAX(CASE WHEN code = '01' THEN id ELSE 0 END) AS Id_1,
       MAX(CASE WHEN code = '02' THEN id ELSE 0 END) AS Id_2
FROM table_2

Please refer to the working fiddle on db<>fiddle

edited Jun 29, 2021 at 13:19

answered Jun 29, 2021 at 10:29

Arulkumar

13.3k14 gold badges51 silver badges76 bronze badges

Collectives™ on Stack Overflow

postgres how to insert values with 2 selects

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related