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)
- values
- (1, 'Joe', 'chemistry => NULL, biochem => null'::hstore);
- select *
- from person
- where interests ? 'chemistry'
- or interests ? 'biochem';
Add Comment
Please, Sign In to add comment