SHARE
TWEET

Untitled

a guest Jun 25th, 2019 52 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top