April 2017
Beginner to intermediate
360 pages
9h 35m
English
Like sets and lists, maps have a literal syntax that allows you to directly set the entire contents of a column:
UPDATE "users" SET "social_identities" = {'twitter': 353637} WHERE "username" = 'alice';
The literal syntax for a map separates keys and values with a colon and optional whitespace, delimits key-value pairs with commas, and encloses the whole thing in curly braces. Both keys and values themselves are written in the literal format for their type.
Read now
Unlock full access