2z6LQNQN

1CREATE TABLE IF NOT EXISTS t1 (a BYTEA NOT NULL,
2                               r_pointer BIGINT,
3                               s_pointer BIGINT,
4                               data BYTEA,
5                              PRIMARY KEY(a, r_pointer ))
6                              PARTITION BY HASH (a); 
7     
8SELECT * FROM t1 WHERE a ='xaaa' order by r_pointer desc limit 1; 
9     
10SELECT * FROM t1
11WHERE  a = ANY ('{xaaa,xbbbb}'::bytea[]) 
12ORDER  BY r_pointer DESC; 
13     
14SELECT t1.*
15FROM   unnest('{xaaa,xbbbb}'::bytea[]) a
16CROSS  JOIN LATERAL (
17   SELECT *
18   FROM   t1
19   WHERE  t1.a = a.a
20   ORDER  BY t1.r_pointer DESC
21   LIMIT  1
22   ) t1;