How to insert records into a table using a nested subquery and the ANY operator in PostgreSQL?

Question

Accepted Answer

INSERT INTO table1 (col1, col2)  
 SELECT col1, col2  
 FROM table2  
 WHERE col3 = ANY (SELECT col3 FROM table3);

Answer

INSERT INTO table1 (col1, col2)  
 SELECT col1, col2  
 FROM table2  
 WHERE col3 NOT ANY (SELECT col3 FROM table3);

Answer

INSERT INTO table1 (col1, col2)  
 SELECT col1, col2  
 FROM table2  
 WHERE col3 IN (SELECT col3 FROM table3);

Answer

INSERT INTO table1 (col1, col2)  
 SELECT col1, col2  
 FROM table2  
 WHERE col3 = (SELECT col3 FROM table3);

Crowdly