[
  {"type":"GenericHeading","value":"# about\n"},
  {"type":"Text","value":"\n"},
  {"type":"Punctuation","value":"\u003c"},
  {"type":"NameTag","value":"div"},
  {"type":"Text","value":" "},
  {"type":"NameAttribute","value":"class"},
  {"type":"Operator","value":"="},
  {"type":"LiteralString","value":"\"html\""},
  {"type":"Punctuation","value":"\u003e"},
  {"type":"Text","value":"HTML"},
  {"type":"Punctuation","value":"\u003c/"},
  {"type":"NameTag","value":"div"},
  {"type":"Punctuation","value":"\u003e"},
  {"type":"Text","value":"\n\nMultiple "},
  {"type":"GenericStrong","value":"**bold**"},
  {"type":"Text","value":" on the "},
  {"type":"GenericStrong","value":"**same line**"},
  {"type":"Text","value":".\n\nMultiple "},
  {"type":"GenericEmph","value":"_italic_"},
  {"type":"Text","value":" on the "},
  {"type":"GenericEmph","value":"*same_line*"},
  {"type":"Text","value":".\n\n"},
  {"type":"GenericSubheading","value":"## user defined function in cql\n"},
  {"type":"Text","value":"\n"},
  {"type":"LiteralString","value":"```javascript\n"},
  {"type":"Text","value":"  "},
  {"type":"NameOther","value":"column"},
  {"type":"Punctuation","value":"."},
  {"type":"NameOther","value":"substring"},
  {"type":"Punctuation","value":"("},
  {"type":"LiteralNumberInteger","value":"0"},
  {"type":"Punctuation","value":","},
  {"type":"NameOther","value":"num"},
  {"type":"Punctuation","value":")"},
  {"type":"Text","value":"\n"},
  {"type":"LiteralString","value":"```"},
  {"type":"Text","value":"\n\n"},
  {"type":"LiteralString","value":"```cql\n"},
  {"type":"Keyword","value":"CREATE"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"FUNCTION"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"IF"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"NOT"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"EXISTS"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Name","value":"cycling"},
  {"type":"Punctuation","value":"."},
  {"type":"Name","value":"left"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Punctuation","value":"("},
  {"type":"Name","value":"column"},
  {"type":"TextWhitespace","value":" "},
  {"type":"NameBuiltin","value":"TEXT"},
  {"type":"Punctuation","value":","},
  {"type":"Name","value":"num"},
  {"type":"TextWhitespace","value":" "},
  {"type":"NameBuiltin","value":"int"},
  {"type":"Punctuation","value":")"},
  {"type":"TextWhitespace","value":"\n"},
  {"type":"Keyword","value":"RETURNS"},
  {"type":"TextWhitespace","value":" "},
  {"type":"KeywordConstant","value":"NULL"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"ON"},
  {"type":"TextWhitespace","value":" "},
  {"type":"KeywordConstant","value":"NULL"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"INPUT"},
  {"type":"TextWhitespace","value":"\n"},
  {"type":"Keyword","value":"RETURNS"},
  {"type":"TextWhitespace","value":" "},
  {"type":"NameBuiltin","value":"text"},
  {"type":"TextWhitespace","value":"\n"},
  {"type":"Keyword","value":"LANGUAGE"},
  {"type":"TextWhitespace","value":" "},
  {"type":"NameBuiltin","value":"javascript"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"AS"},
  {"type":"TextWhitespace","value":" "},
  {"type":"LiteralStringHeredoc","value":"$$"},
  {"type":"Text","value":"\n  "},
  {"type":"NameOther","value":"column"},
  {"type":"Punctuation","value":"."},
  {"type":"NameOther","value":"substring"},
  {"type":"Punctuation","value":"("},
  {"type":"LiteralNumberInteger","value":"0"},
  {"type":"Punctuation","value":","},
  {"type":"NameOther","value":"num"},
  {"type":"Punctuation","value":")"},
  {"type":"Text","value":"\n"},
  {"type":"LiteralStringHeredoc","value":"$$"},
  {"type":"Punctuation","value":";"},
  {"type":"TextWhitespace","value":"\n\n"},
  {"type":"Keyword","value":"CREATE"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"OR"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"REPLACE"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"FUNCTION"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Name","value":"cycling"},
  {"type":"Punctuation","value":"."},
  {"type":"Name","value":"fLog"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Punctuation","value":"("},
  {"type":"Keyword","value":"input"},
  {"type":"TextWhitespace","value":" "},
  {"type":"NameBuiltin","value":"double"},
  {"type":"Punctuation","value":")"},
  {"type":"TextWhitespace","value":"\n"},
  {"type":"Keyword","value":"CALLED"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"ON"},
  {"type":"TextWhitespace","value":" "},
  {"type":"KeywordConstant","value":"NULL"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"INPUT"},
  {"type":"TextWhitespace","value":"\n"},
  {"type":"Keyword","value":"RETURNS"},
  {"type":"TextWhitespace","value":" "},
  {"type":"NameBuiltin","value":"double"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"LANGUAGE"},
  {"type":"TextWhitespace","value":" "},
  {"type":"NameBuiltin","value":"java"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"AS"},
  {"type":"TextWhitespace","value":"\n"},
  {"type":"LiteralStringHeredoc","value":"'"},
  {"type":"Keyword","value":"return"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Name","value":"Double"},
  {"type":"Punctuation","value":"."},
  {"type":"NameAttribute","value":"valueOf"},
  {"type":"Punctuation","value":"("},
  {"type":"Name","value":"Math"},
  {"type":"Punctuation","value":"."},
  {"type":"NameAttribute","value":"log"},
  {"type":"Punctuation","value":"("},
  {"type":"Name","value":"input"},
  {"type":"Punctuation","value":"."},
  {"type":"NameAttribute","value":"doubleValue"},
  {"type":"Punctuation","value":"()));"},
  {"type":"LiteralStringHeredoc","value":"'"},
  {"type":"Punctuation","value":";"},
  {"type":"TextWhitespace","value":"\n"},
  {"type":"LiteralString","value":"```"},
  {"type":"Text","value":"\n\n"},
  {"type":"LiteralString","value":"```postgres\n"},
  {"type":"Keyword","value":"DROP"},
  {"type":"Text","value":" "},
  {"type":"Keyword","value":"TABLE"},
  {"type":"Text","value":" "},
  {"type":"Keyword","value":"IF"},
  {"type":"Text","value":" "},
  {"type":"Keyword","value":"EXISTS"},
  {"type":"Text","value":" "},
  {"type":"Name","value":"emp"},
  {"type":"Text","value":" "},
  {"type":"Keyword","value":"CASCADE"},
  {"type":"Punctuation","value":";"},
  {"type":"Text","value":"\n\n"},
  {"type":"Keyword","value":"CREATE"},
  {"type":"Text","value":" "},
  {"type":"Keyword","value":"TABLE"},
  {"type":"Text","value":" "},
  {"type":"Name","value":"emp"},
  {"type":"Text","value":" "},
  {"type":"Punctuation","value":"("},
  {"type":"Text","value":"\n  "},
  {"type":"Name","value":"empname"},
  {"type":"Text","value":" "},
  {"type":"NameBuiltin","value":"text"},
  {"type":"Punctuation","value":","},
  {"type":"Text","value":"\n  "},
  {"type":"Name","value":"salary"},
  {"type":"Text","value":" "},
  {"type":"NameBuiltin","value":"integer"},
  {"type":"Punctuation","value":","},
  {"type":"Text","value":"\n  "},
  {"type":"Name","value":"last_date"},
  {"type":"Text","value":" "},
  {"type":"NameBuiltin","value":"timestamp"},
  {"type":"Punctuation","value":","},
  {"type":"Text","value":"\n  "},
  {"type":"Name","value":"last_user"},
  {"type":"Text","value":" "},
  {"type":"NameBuiltin","value":"text"},
  {"type":"Text","value":"\n"},
  {"type":"Punctuation","value":");"},
  {"type":"Text","value":"\n\n"},
  {"type":"Keyword","value":"select"},
  {"type":"Text","value":"\n  "},
  {"type":"LiteralStringHeredoc","value":"$my_tag$aoeuaoeu$my_tag$"},
  {"type":"Text","value":" "},
  {"type":"Keyword","value":"as"},
  {"type":"Text","value":" "},
  {"type":"Name","value":"blah"},
  {"type":"Text","value":"\n"},
  {"type":"Punctuation","value":";"},
  {"type":"Text","value":"\n\n"},
  {"type":"Keyword","value":"CREATE"},
  {"type":"Text","value":" "},
  {"type":"Keyword","value":"OR"},
  {"type":"Text","value":" "},
  {"type":"Keyword","value":"REPLACE"},
  {"type":"Text","value":" "},
  {"type":"Keyword","value":"FUNCTION"},
  {"type":"Text","value":" "},
  {"type":"Name","value":"emp_stamp"},
  {"type":"Punctuation","value":"()"},
  {"type":"Text","value":" "},
  {"type":"Keyword","value":"RETURNS"},
  {"type":"Text","value":" "},
  {"type":"Keyword","value":"trigger"},
  {"type":"Text","value":" "},
  {"type":"Keyword","value":"AS"},
  {"type":"Text","value":" "},
  {"type":"LiteralStringHeredoc","value":"$emp_stamp$"},
  {"type":"TextWhitespace","value":"\n"},
  {"type":"Keyword","value":"BEGIN"},
  {"type":"TextWhitespace","value":"\n  "},
  {"type":"CommentSingle","value":"-- Check that empname and salary are given\n"},
  {"type":"TextWhitespace","value":"  "},
  {"type":"Keyword","value":"IF"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Name","value":"NEW"},
  {"type":"LiteralNumberFloat","value":"."},
  {"type":"Name","value":"empname"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"IS"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"NULL"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"THEN"},
  {"type":"TextWhitespace","value":"\n    "},
  {"type":"Keyword","value":"RAISE"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"EXCEPTION"},
  {"type":"TextWhitespace","value":" "},
  {"type":"LiteralStringSingle","value":"'empname cannot be null'"},
  {"type":"Punctuation","value":";"},
  {"type":"TextWhitespace","value":"\n  "},
  {"type":"Keyword","value":"END"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"IF"},
  {"type":"Punctuation","value":";"},
  {"type":"TextWhitespace","value":"\n  "},
  {"type":"Keyword","value":"IF"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Name","value":"NEW"},
  {"type":"LiteralNumberFloat","value":"."},
  {"type":"Name","value":"salary"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"IS"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"NULL"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"THEN"},
  {"type":"TextWhitespace","value":"\n    "},
  {"type":"Keyword","value":"RAISE"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"EXCEPTION"},
  {"type":"TextWhitespace","value":" "},
  {"type":"LiteralStringSingle","value":"'% cannot have null salary'"},
  {"type":"Punctuation","value":","},
  {"type":"TextWhitespace","value":" "},
  {"type":"Name","value":"NEW"},
  {"type":"LiteralNumberFloat","value":"."},
  {"type":"Name","value":"empname"},
  {"type":"Punctuation","value":";"},
  {"type":"TextWhitespace","value":"\n  "},
  {"type":"Keyword","value":"END"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"IF"},
  {"type":"Punctuation","value":";"},
  {"type":"TextWhitespace","value":"\n\n  "},
  {"type":"CommentSingle","value":"-- Who works for us when she must pay for it?\n"},
  {"type":"TextWhitespace","value":"  "},
  {"type":"Keyword","value":"IF"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Name","value":"NEW"},
  {"type":"LiteralNumberFloat","value":"."},
  {"type":"Name","value":"salary"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Operator","value":"\u003c"},
  {"type":"TextWhitespace","value":" "},
  {"type":"LiteralNumberFloat","value":"0"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"THEN"},
  {"type":"TextWhitespace","value":"\n    "},
  {"type":"Keyword","value":"RAISE"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"EXCEPTION"},
  {"type":"TextWhitespace","value":" "},
  {"type":"LiteralStringSingle","value":"'% cannot have a negative salary'"},
  {"type":"Punctuation","value":","},
  {"type":"TextWhitespace","value":" "},
  {"type":"Name","value":"NEW"},
  {"type":"LiteralNumberFloat","value":"."},
  {"type":"Name","value":"empname"},
  {"type":"Punctuation","value":";"},
  {"type":"TextWhitespace","value":"\n  "},
  {"type":"Keyword","value":"END"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"IF"},
  {"type":"Punctuation","value":";"},
  {"type":"TextWhitespace","value":"\n\n  "},
  {"type":"CommentSingle","value":"-- Remember who changed the payroll when\n"},
  {"type":"TextWhitespace","value":"  "},
  {"type":"Name","value":"NEW"},
  {"type":"LiteralNumberFloat","value":"."},
  {"type":"Name","value":"last_date"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Operator","value":":="},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"current_timestamp"},
  {"type":"Punctuation","value":";"},
  {"type":"TextWhitespace","value":"\n  "},
  {"type":"Name","value":"NEW"},
  {"type":"LiteralNumberFloat","value":"."},
  {"type":"Name","value":"last_user"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Operator","value":":="},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"current_user"},
  {"type":"Punctuation","value":";"},
  {"type":"TextWhitespace","value":"\n  "},
  {"type":"Keyword","value":"RETURN"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Name","value":"NEW"},
  {"type":"Punctuation","value":";"},
  {"type":"TextWhitespace","value":"\n"},
  {"type":"Keyword","value":"END"},
  {"type":"Punctuation","value":";"},
  {"type":"TextWhitespace","value":"\n"},
  {"type":"LiteralStringHeredoc","value":"$emp_stamp$"},
  {"type":"Text","value":" "},
  {"type":"Keyword","value":"LANGUAGE"},
  {"type":"Text","value":" "},
  {"type":"LiteralStringSingle","value":"plpgsql"},
  {"type":"Punctuation","value":";"},
  {"type":"Text","value":"\n\n"},
  {"type":"Keyword","value":"CREATE"},
  {"type":"Text","value":" "},
  {"type":"Keyword","value":"TRIGGER"},
  {"type":"Text","value":" "},
  {"type":"Name","value":"emp_stamp"},
  {"type":"Text","value":" "},
  {"type":"Keyword","value":"BEFORE"},
  {"type":"Text","value":" "},
  {"type":"Keyword","value":"INSERT"},
  {"type":"Text","value":" "},
  {"type":"Keyword","value":"OR"},
  {"type":"Text","value":" "},
  {"type":"Keyword","value":"UPDATE"},
  {"type":"Text","value":" "},
  {"type":"Keyword","value":"ON"},
  {"type":"Text","value":" "},
  {"type":"Name","value":"emp"},
  {"type":"Text","value":"\n  "},
  {"type":"Keyword","value":"FOR"},
  {"type":"Text","value":" "},
  {"type":"Keyword","value":"EACH"},
  {"type":"Text","value":" "},
  {"type":"Keyword","value":"ROW"},
  {"type":"Text","value":" "},
  {"type":"Keyword","value":"EXECUTE"},
  {"type":"Text","value":" "},
  {"type":"Keyword","value":"PROCEDURE"},
  {"type":"Text","value":" "},
  {"type":"Name","value":"emp_stamp"},
  {"type":"Punctuation","value":"();"},
  {"type":"Text","value":"\n\n"},
  {"type":"Keyword","value":"DO"},
  {"type":"Text","value":" "},
  {"type":"Keyword","value":"language"},
  {"type":"Text","value":" "},
  {"type":"LiteralStringSingle","value":"plpgsql"},
  {"type":"Text","value":" "},
  {"type":"LiteralStringHeredoc","value":"$$"},
  {"type":"TextWhitespace","value":"\n"},
  {"type":"Keyword","value":"declare"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Name","value":"r"},
  {"type":"TextWhitespace","value":" "},
  {"type":"NameBuiltin","value":"record"},
  {"type":"Punctuation","value":";"},
  {"type":"TextWhitespace","value":"\n"},
  {"type":"Keyword","value":"begin"},
  {"type":"TextWhitespace","value":"\n  "},
  {"type":"Keyword","value":"for"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Name","value":"r"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"in"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"select"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Operator","value":"*"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"from"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Name","value":"books"},
  {"type":"TextWhitespace","value":"\n"},
  {"type":"Keyword","value":"loop"},
  {"type":"TextWhitespace","value":"\n  "},
  {"type":"Keyword","value":"execute"},
  {"type":"TextWhitespace","value":" "},
  {"type":"LiteralStringSingle","value":"'select '''"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Operator","value":"||"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Name","value":"r"},
  {"type":"LiteralNumberFloat","value":"."},
  {"type":"Name","value":"title"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Operator","value":"||"},
  {"type":"TextWhitespace","value":" "},
  {"type":"LiteralStringSingle","value":"''''"},
  {"type":"Punctuation","value":";"},
  {"type":"TextWhitespace","value":"\n"},
  {"type":"Keyword","value":"end"},
  {"type":"TextWhitespace","value":" "},
  {"type":"Keyword","value":"loop"},
  {"type":"Punctuation","value":";"},
  {"type":"TextWhitespace","value":"\n"},
  {"type":"Keyword","value":"end"},
  {"type":"TextWhitespace","value":"\n"},
  {"type":"LiteralStringHeredoc","value":"$$"},
  {"type":"Punctuation","value":";"},
  {"type":"Text","value":"\n\n"},
  {"type":"Keyword","value":"DO"},
  {"type":"Text","value":" "},
  {"type":"LiteralStringHeredoc","value":"$$\ndeclare r record;\nbegin\n  for r in select * from books\nloop\n  execute 'select ''' || r.title || '''';\nend loop;\nend\n$$"},
  {"type":"Punctuation","value":";"},
  {"type":"Text","value":"\n"},
  {"type":"LiteralString","value":"```"},
  {"type":"Text","value":"\n"}
]