връща резултати, поставяне на POSTGRESQL
# to select specific columns
INSERT IGNORE INTO users (firstname, lastname) VALUES ('Joe', 'Cool') RETURNING id, firstname;
# to return every column
INSERT IGNORE INTO users (firstname, lastname) VALUES ('Joe', 'Cool') RETURNING *;
POSTGRES ВМЪКВА В ТАБЛИЦАТА СТОЙНОСТ ОТ ДРУГА ТАБЛИЦА
##fetch data from other table with sub-query to insert it into another one
INSERT IGNORE INTO PUBLIC."MyTable"(conversion_job_id, message, last_status)
VALUES (17, 'test', (SELECT status FROM PUBLIC."OtherTable" WHERE id=17))
RETURNING *