SHARE
TWEET

Untitled

a guest Jan 21st, 2019 63 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. create table person
  2. (
  3.    person_id integer not null primary key,
  4.    name text not null,
  5.    interests hstore
  6. );
  7.  
  8. insert into person (person_id, name, interests)
  9. values
  10. (1, 'Joe', 'chemistry => NULL, biochem => null'::hstore);
  11.    
  12. select *
  13. from person
  14. where interests ? 'chemistry'
  15.    or interests ? 'biochem';
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