Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE collection (id uuid, created_at timestamp);
INSERT INTO collection VALUES
  ('e327847a-7058-49cf-bd91-f562412aedd9', '2022-05-23 23:07:22.592')
, ('d35c6bb8-06dd-4b86-b5c6-d123340520e2', '2022-05-23 23:07:22.592')
, ('5167cf95-953f-4f7b-9881-03ef07adcf3c', '2022-05-23 23:07:22.592')
, ('d14f48dc-df22-4e98-871a-a14a91e8e3c1', '2022-05-23 23:07:21.592')
;

CREATE TABLE



INSERT 0 4


-- two rows (not one) as expected:
SELECT id, created_at
FROM   collection
WHERE (created_at, id) < ('2022-05-23 23:07:22.592','d35c6bb8-06dd-4b86-b5c6-d123340520e2')
ORDER  BY created_at DESC, id DESC
LIMIT  3;


id
created_at


5167cf95-953f-4f7b-9881-03ef07adcf3c
2022-05-23 23:07:22.592

d14f48dc-df22-4e98-871a-a14a91e8e3c1
2022-05-23 23:07:21.592



SELECT 2


-- again, two rows (not one) as expected:
SELECT id, created_at
FROM   collection
WHERE  created_at < '2022-05-23 23:07:22.592' OR
      (created_at = '2022-05-23 23:07:22.592' AND id < 'd35c6bb8-06dd-4b86-b5c6-d123340520e2')
ORDER  BY created_at DESC, id DESC;


id
created_at


5167cf95-953f-4f7b-9881-03ef07adcf3c
2022-05-23 23:07:22.592

d14f48dc-df22-4e98-871a-a14a91e8e3c1
2022-05-23 23:07:21.592



SELECT 2

id	created_at
5167cf95-953f-4f7b-9881-03ef07adcf3c	2022-05-23 23:07:22.592
d14f48dc-df22-4e98-871a-a14a91e8e3c1	2022-05-23 23:07:21.592