These are the SQL syntax examples and my preparatory notes for the talk I am giving at PGConf Silicon Valley 2016 on November 16th*. Talk abstract is here: http://www.pgconfsv.com/postgresql%E2%80%99s-secret-nosql-superpowers-0
- xml: http://www.postgresql.org/docs/9.5/static/functions-xml.html
- hstore: http://www.postgresql.org/docs/9.5/static/hstore.html
- json & jsonb: http://www.postgresql.org/docs/9.5/static/functions-json.html
Source for the xml sample: https://msdn.microsoft.com/en-us/library/ms762271(v=vs.85).aspx
*Most material was originally presented at PGConfUS in Brooklyn, NY on April 20th.