Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. CREATE 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.  
  8. SELECT * FROM t1 WHERE a ='xaaa' order by r_pointer desc limit 1;
  9.  
  10. SELECT * FROM t1 WHERE a =ANY ('{xaaa,xbbbb}'::bytea[])
  11. order by r_pointer desc;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement