Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS t1 (a BYTEA NOT NULL,
- r_pointer BIGINT,
- s_pointer BIGINT,
- data BYTEA,
- PRIMARY KEY(a, r_pointer ))
- PARTITION BY HASH (a);
- SELECT * FROM t1 WHERE a ='xaaa' order by r_pointer desc limit 1;
- SELECT * FROM t1 WHERE a =ANY ('{xaaa,xbbbb}'::bytea[])
- order by r_pointer desc;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement