Guest User

Untitled

a guest
Jan 21st, 2019
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  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';
Add Comment
Please, Sign In to add comment