Slide 16
Slide 16 text
INSERT INTO products (name, attributes) VALUES (
'Geek Love: A Novel’,
'author => "Katherine Dunn",
pages => 368,
category => fiction’
);
SELECT name,
attributes->'author' as author
FROM products
WHERE attributes->'category' = 'fiction’;
CREATE INDEX idx_products ON products USING
gin(attributes);