a guest Jan 21st, 2019 63 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- create table person
- person_id integer not null primary key,
- name text not null,
- interests hstore
- insert into person (person_id, name, interests)
- (1, 'Joe', 'chemistry => NULL, biochem => null'::hstore);
- select *
- from person
- where interests ? 'chemistry'
- or interests ? 'biochem';
RAW Paste Data