How to sort list by time using id in Postgresql?

Question

PostgreSQL

+ another question, is it possible to do insert and update in one query?
for example, to make an insert into the table if there is no such key. while I do this. insert, if there is no error, then you can update. Thank you!

Answer 1

Sorting solved using subqueries.
SELECT * FROM post WHERE date >(SELECT datepst FROM post WHERE id =$1) ORDER BY date
ASC In such a case, using transactions worked.

Answer 2

1. order by id
2. ON CONFLICT ... DO UPDATE for INSERT