Select * from ( select DISTINCT on (sendto) sendto,userid,text,timestamp from((select DISTINCT

Question

Select * from ( select DISTINCT on (sendto) sendto,userid,text,timestamp from((select DISTINCT

on (sendto) sendto,userid,text,timestamp from messages where userid = 1 order by sendto, timestamp DESC )union(select DISTINCT on (userid) userid,sendto,text,timestamp from messages where sendto = 1 order by userid, timestamp DESC )) as b order by sendto, timestamp DESC
) as bb order by timestamp desc

Добрый вечер, как сделать более эффективнее запрос ?

#backend #devops #pgsql #programming #russian

0

03.12.2021