1[
2 {"type":"GenericHeading","value":"# about\n"},
3 {"type":"Text","value":"\n"},
4 {"type":"Punctuation","value":"\u003c"},
5 {"type":"NameTag","value":"div"},
6 {"type":"Text","value":" "},
7 {"type":"NameAttribute","value":"class"},
8 {"type":"Operator","value":"="},
9 {"type":"LiteralString","value":"\"html\""},
10 {"type":"Punctuation","value":"\u003e"},
11 {"type":"Text","value":"HTML"},
12 {"type":"Punctuation","value":"\u003c/"},
13 {"type":"NameTag","value":"div"},
14 {"type":"Punctuation","value":"\u003e"},
15 {"type":"Text","value":"\n\nMultiple "},
16 {"type":"GenericStrong","value":"**bold**"},
17 {"type":"Text","value":" on the "},
18 {"type":"GenericStrong","value":"**same line**"},
19 {"type":"Text","value":".\n\nMultiple "},
20 {"type":"GenericEmph","value":"_italic_"},
21 {"type":"Text","value":" on the "},
22 {"type":"GenericEmph","value":"*same_line*"},
23 {"type":"Text","value":".\n\n"},
24 {"type":"GenericSubheading","value":"## user defined function in cql\n"},
25 {"type":"Text","value":"\n"},
26 {"type":"LiteralString","value":"```javascript\n"},
27 {"type":"Text","value":" "},
28 {"type":"NameOther","value":"column"},
29 {"type":"Punctuation","value":"."},
30 {"type":"NameOther","value":"substring"},
31 {"type":"Punctuation","value":"("},
32 {"type":"LiteralNumberInteger","value":"0"},
33 {"type":"Punctuation","value":","},
34 {"type":"NameOther","value":"num"},
35 {"type":"Punctuation","value":")"},
36 {"type":"Text","value":"\n"},
37 {"type":"LiteralString","value":"```"},
38 {"type":"Text","value":"\n\n"},
39 {"type":"LiteralString","value":"```cql\n"},
40 {"type":"Keyword","value":"CREATE"},
41 {"type":"TextWhitespace","value":" "},
42 {"type":"Keyword","value":"FUNCTION"},
43 {"type":"TextWhitespace","value":" "},
44 {"type":"Keyword","value":"IF"},
45 {"type":"TextWhitespace","value":" "},
46 {"type":"Keyword","value":"NOT"},
47 {"type":"TextWhitespace","value":" "},
48 {"type":"Keyword","value":"EXISTS"},
49 {"type":"TextWhitespace","value":" "},
50 {"type":"Name","value":"cycling"},
51 {"type":"Punctuation","value":"."},
52 {"type":"Name","value":"left"},
53 {"type":"TextWhitespace","value":" "},
54 {"type":"Punctuation","value":"("},
55 {"type":"Name","value":"column"},
56 {"type":"TextWhitespace","value":" "},
57 {"type":"NameBuiltin","value":"TEXT"},
58 {"type":"Punctuation","value":","},
59 {"type":"Name","value":"num"},
60 {"type":"TextWhitespace","value":" "},
61 {"type":"NameBuiltin","value":"int"},
62 {"type":"Punctuation","value":")"},
63 {"type":"TextWhitespace","value":"\n"},
64 {"type":"Keyword","value":"RETURNS"},
65 {"type":"TextWhitespace","value":" "},
66 {"type":"KeywordConstant","value":"NULL"},
67 {"type":"TextWhitespace","value":" "},
68 {"type":"Keyword","value":"ON"},
69 {"type":"TextWhitespace","value":" "},
70 {"type":"KeywordConstant","value":"NULL"},
71 {"type":"TextWhitespace","value":" "},
72 {"type":"Keyword","value":"INPUT"},
73 {"type":"TextWhitespace","value":"\n"},
74 {"type":"Keyword","value":"RETURNS"},
75 {"type":"TextWhitespace","value":" "},
76 {"type":"NameBuiltin","value":"text"},
77 {"type":"TextWhitespace","value":"\n"},
78 {"type":"Keyword","value":"LANGUAGE"},
79 {"type":"TextWhitespace","value":" "},
80 {"type":"NameBuiltin","value":"javascript"},
81 {"type":"TextWhitespace","value":" "},
82 {"type":"Keyword","value":"AS"},
83 {"type":"TextWhitespace","value":" "},
84 {"type":"LiteralStringHeredoc","value":"$$"},
85 {"type":"Text","value":"\n "},
86 {"type":"NameOther","value":"column"},
87 {"type":"Punctuation","value":"."},
88 {"type":"NameOther","value":"substring"},
89 {"type":"Punctuation","value":"("},
90 {"type":"LiteralNumberInteger","value":"0"},
91 {"type":"Punctuation","value":","},
92 {"type":"NameOther","value":"num"},
93 {"type":"Punctuation","value":")"},
94 {"type":"Text","value":"\n"},
95 {"type":"LiteralStringHeredoc","value":"$$"},
96 {"type":"Punctuation","value":";"},
97 {"type":"TextWhitespace","value":"\n\n"},
98 {"type":"Keyword","value":"CREATE"},
99 {"type":"TextWhitespace","value":" "},
100 {"type":"Keyword","value":"OR"},
101 {"type":"TextWhitespace","value":" "},
102 {"type":"Keyword","value":"REPLACE"},
103 {"type":"TextWhitespace","value":" "},
104 {"type":"Keyword","value":"FUNCTION"},
105 {"type":"TextWhitespace","value":" "},
106 {"type":"Name","value":"cycling"},
107 {"type":"Punctuation","value":"."},
108 {"type":"Name","value":"fLog"},
109 {"type":"TextWhitespace","value":" "},
110 {"type":"Punctuation","value":"("},
111 {"type":"Keyword","value":"input"},
112 {"type":"TextWhitespace","value":" "},
113 {"type":"NameBuiltin","value":"double"},
114 {"type":"Punctuation","value":")"},
115 {"type":"TextWhitespace","value":"\n"},
116 {"type":"Keyword","value":"CALLED"},
117 {"type":"TextWhitespace","value":" "},
118 {"type":"Keyword","value":"ON"},
119 {"type":"TextWhitespace","value":" "},
120 {"type":"KeywordConstant","value":"NULL"},
121 {"type":"TextWhitespace","value":" "},
122 {"type":"Keyword","value":"INPUT"},
123 {"type":"TextWhitespace","value":"\n"},
124 {"type":"Keyword","value":"RETURNS"},
125 {"type":"TextWhitespace","value":" "},
126 {"type":"NameBuiltin","value":"double"},
127 {"type":"TextWhitespace","value":" "},
128 {"type":"Keyword","value":"LANGUAGE"},
129 {"type":"TextWhitespace","value":" "},
130 {"type":"NameBuiltin","value":"java"},
131 {"type":"TextWhitespace","value":" "},
132 {"type":"Keyword","value":"AS"},
133 {"type":"TextWhitespace","value":"\n"},
134 {"type":"LiteralStringHeredoc","value":"'"},
135 {"type":"Keyword","value":"return"},
136 {"type":"Text","value":" "},
137 {"type":"Name","value":"Double"},
138 {"type":"Operator","value":"."},
139 {"type":"NameAttribute","value":"valueOf"},
140 {"type":"Operator","value":"("},
141 {"type":"Name","value":"Math"},
142 {"type":"Operator","value":"."},
143 {"type":"NameAttribute","value":"log"},
144 {"type":"Operator","value":"("},
145 {"type":"Name","value":"input"},
146 {"type":"Operator","value":"."},
147 {"type":"NameAttribute","value":"doubleValue"},
148 {"type":"Operator","value":"()));"},
149 {"type":"LiteralStringHeredoc","value":"'"},
150 {"type":"Punctuation","value":";"},
151 {"type":"TextWhitespace","value":"\n"},
152 {"type":"LiteralString","value":"```"},
153 {"type":"Text","value":"\n\n"},
154 {"type":"LiteralString","value":"```postgres\n"},
155 {"type":"Keyword","value":"DROP"},
156 {"type":"Text","value":" "},
157 {"type":"Keyword","value":"TABLE"},
158 {"type":"Text","value":" "},
159 {"type":"Keyword","value":"IF"},
160 {"type":"Text","value":" "},
161 {"type":"Keyword","value":"EXISTS"},
162 {"type":"Text","value":" "},
163 {"type":"Name","value":"emp"},
164 {"type":"Text","value":" "},
165 {"type":"Keyword","value":"CASCADE"},
166 {"type":"Punctuation","value":";"},
167 {"type":"Text","value":"\n\n"},
168 {"type":"Keyword","value":"CREATE"},
169 {"type":"Text","value":" "},
170 {"type":"Keyword","value":"TABLE"},
171 {"type":"Text","value":" "},
172 {"type":"Name","value":"emp"},
173 {"type":"Text","value":" "},
174 {"type":"Punctuation","value":"("},
175 {"type":"Text","value":"\n "},
176 {"type":"Name","value":"empname"},
177 {"type":"Text","value":" "},
178 {"type":"NameBuiltin","value":"text"},
179 {"type":"Punctuation","value":","},
180 {"type":"Text","value":"\n "},
181 {"type":"Name","value":"salary"},
182 {"type":"Text","value":" "},
183 {"type":"NameBuiltin","value":"integer"},
184 {"type":"Punctuation","value":","},
185 {"type":"Text","value":"\n "},
186 {"type":"Name","value":"last_date"},
187 {"type":"Text","value":" "},
188 {"type":"NameBuiltin","value":"timestamp"},
189 {"type":"Punctuation","value":","},
190 {"type":"Text","value":"\n "},
191 {"type":"Name","value":"last_user"},
192 {"type":"Text","value":" "},
193 {"type":"NameBuiltin","value":"text"},
194 {"type":"Text","value":"\n"},
195 {"type":"Punctuation","value":");"},
196 {"type":"Text","value":"\n\n"},
197 {"type":"Keyword","value":"select"},
198 {"type":"Text","value":"\n "},
199 {"type":"LiteralStringHeredoc","value":"$my_tag$aoeuaoeu$my_tag$"},
200 {"type":"Text","value":" "},
201 {"type":"Keyword","value":"as"},
202 {"type":"Text","value":" "},
203 {"type":"Name","value":"blah"},
204 {"type":"Text","value":"\n"},
205 {"type":"Punctuation","value":";"},
206 {"type":"Text","value":"\n\n"},
207 {"type":"Keyword","value":"CREATE"},
208 {"type":"Text","value":" "},
209 {"type":"Keyword","value":"OR"},
210 {"type":"Text","value":" "},
211 {"type":"Keyword","value":"REPLACE"},
212 {"type":"Text","value":" "},
213 {"type":"Keyword","value":"FUNCTION"},
214 {"type":"Text","value":" "},
215 {"type":"Name","value":"emp_stamp"},
216 {"type":"Punctuation","value":"()"},
217 {"type":"Text","value":" "},
218 {"type":"Keyword","value":"RETURNS"},
219 {"type":"Text","value":" "},
220 {"type":"Keyword","value":"trigger"},
221 {"type":"Text","value":" "},
222 {"type":"Keyword","value":"AS"},
223 {"type":"Text","value":" "},
224 {"type":"LiteralStringHeredoc","value":"$emp_stamp$"},
225 {"type":"TextWhitespace","value":"\n"},
226 {"type":"Keyword","value":"BEGIN"},
227 {"type":"TextWhitespace","value":"\n "},
228 {"type":"CommentSingle","value":"-- Check that empname and salary are given\n"},
229 {"type":"TextWhitespace","value":" "},
230 {"type":"Keyword","value":"IF"},
231 {"type":"TextWhitespace","value":" "},
232 {"type":"Name","value":"NEW"},
233 {"type":"LiteralNumberFloat","value":"."},
234 {"type":"Name","value":"empname"},
235 {"type":"TextWhitespace","value":" "},
236 {"type":"Keyword","value":"IS"},
237 {"type":"TextWhitespace","value":" "},
238 {"type":"Keyword","value":"NULL"},
239 {"type":"TextWhitespace","value":" "},
240 {"type":"Keyword","value":"THEN"},
241 {"type":"TextWhitespace","value":"\n "},
242 {"type":"Keyword","value":"RAISE"},
243 {"type":"TextWhitespace","value":" "},
244 {"type":"Keyword","value":"EXCEPTION"},
245 {"type":"TextWhitespace","value":" "},
246 {"type":"LiteralStringSingle","value":"'empname cannot be null'"},
247 {"type":"Punctuation","value":";"},
248 {"type":"TextWhitespace","value":"\n "},
249 {"type":"Keyword","value":"END"},
250 {"type":"TextWhitespace","value":" "},
251 {"type":"Keyword","value":"IF"},
252 {"type":"Punctuation","value":";"},
253 {"type":"TextWhitespace","value":"\n "},
254 {"type":"Keyword","value":"IF"},
255 {"type":"TextWhitespace","value":" "},
256 {"type":"Name","value":"NEW"},
257 {"type":"LiteralNumberFloat","value":"."},
258 {"type":"Name","value":"salary"},
259 {"type":"TextWhitespace","value":" "},
260 {"type":"Keyword","value":"IS"},
261 {"type":"TextWhitespace","value":" "},
262 {"type":"Keyword","value":"NULL"},
263 {"type":"TextWhitespace","value":" "},
264 {"type":"Keyword","value":"THEN"},
265 {"type":"TextWhitespace","value":"\n "},
266 {"type":"Keyword","value":"RAISE"},
267 {"type":"TextWhitespace","value":" "},
268 {"type":"Keyword","value":"EXCEPTION"},
269 {"type":"TextWhitespace","value":" "},
270 {"type":"LiteralStringSingle","value":"'% cannot have null salary'"},
271 {"type":"Punctuation","value":","},
272 {"type":"TextWhitespace","value":" "},
273 {"type":"Name","value":"NEW"},
274 {"type":"LiteralNumberFloat","value":"."},
275 {"type":"Name","value":"empname"},
276 {"type":"Punctuation","value":";"},
277 {"type":"TextWhitespace","value":"\n "},
278 {"type":"Keyword","value":"END"},
279 {"type":"TextWhitespace","value":" "},
280 {"type":"Keyword","value":"IF"},
281 {"type":"Punctuation","value":";"},
282 {"type":"TextWhitespace","value":"\n\n "},
283 {"type":"CommentSingle","value":"-- Who works for us when she must pay for it?\n"},
284 {"type":"TextWhitespace","value":" "},
285 {"type":"Keyword","value":"IF"},
286 {"type":"TextWhitespace","value":" "},
287 {"type":"Name","value":"NEW"},
288 {"type":"LiteralNumberFloat","value":"."},
289 {"type":"Name","value":"salary"},
290 {"type":"TextWhitespace","value":" "},
291 {"type":"Operator","value":"\u003c"},
292 {"type":"TextWhitespace","value":" "},
293 {"type":"LiteralNumberFloat","value":"0"},
294 {"type":"TextWhitespace","value":" "},
295 {"type":"Keyword","value":"THEN"},
296 {"type":"TextWhitespace","value":"\n "},
297 {"type":"Keyword","value":"RAISE"},
298 {"type":"TextWhitespace","value":" "},
299 {"type":"Keyword","value":"EXCEPTION"},
300 {"type":"TextWhitespace","value":" "},
301 {"type":"LiteralStringSingle","value":"'% cannot have a negative salary'"},
302 {"type":"Punctuation","value":","},
303 {"type":"TextWhitespace","value":" "},
304 {"type":"Name","value":"NEW"},
305 {"type":"LiteralNumberFloat","value":"."},
306 {"type":"Name","value":"empname"},
307 {"type":"Punctuation","value":";"},
308 {"type":"TextWhitespace","value":"\n "},
309 {"type":"Keyword","value":"END"},
310 {"type":"TextWhitespace","value":" "},
311 {"type":"Keyword","value":"IF"},
312 {"type":"Punctuation","value":";"},
313 {"type":"TextWhitespace","value":"\n\n "},
314 {"type":"CommentSingle","value":"-- Remember who changed the payroll when\n"},
315 {"type":"TextWhitespace","value":" "},
316 {"type":"Name","value":"NEW"},
317 {"type":"LiteralNumberFloat","value":"."},
318 {"type":"Name","value":"last_date"},
319 {"type":"TextWhitespace","value":" "},
320 {"type":"Operator","value":":="},
321 {"type":"TextWhitespace","value":" "},
322 {"type":"Keyword","value":"current_timestamp"},
323 {"type":"Punctuation","value":";"},
324 {"type":"TextWhitespace","value":"\n "},
325 {"type":"Name","value":"NEW"},
326 {"type":"LiteralNumberFloat","value":"."},
327 {"type":"Name","value":"last_user"},
328 {"type":"TextWhitespace","value":" "},
329 {"type":"Operator","value":":="},
330 {"type":"TextWhitespace","value":" "},
331 {"type":"Keyword","value":"current_user"},
332 {"type":"Punctuation","value":";"},
333 {"type":"TextWhitespace","value":"\n "},
334 {"type":"Keyword","value":"RETURN"},
335 {"type":"TextWhitespace","value":" "},
336 {"type":"Name","value":"NEW"},
337 {"type":"Punctuation","value":";"},
338 {"type":"TextWhitespace","value":"\n"},
339 {"type":"Keyword","value":"END"},
340 {"type":"Punctuation","value":";"},
341 {"type":"TextWhitespace","value":"\n"},
342 {"type":"LiteralStringHeredoc","value":"$emp_stamp$"},
343 {"type":"Text","value":" "},
344 {"type":"Keyword","value":"LANGUAGE"},
345 {"type":"Text","value":" "},
346 {"type":"LiteralStringSingle","value":"plpgsql"},
347 {"type":"Punctuation","value":";"},
348 {"type":"Text","value":"\n\n"},
349 {"type":"Keyword","value":"CREATE"},
350 {"type":"Text","value":" "},
351 {"type":"Keyword","value":"TRIGGER"},
352 {"type":"Text","value":" "},
353 {"type":"Name","value":"emp_stamp"},
354 {"type":"Text","value":" "},
355 {"type":"Keyword","value":"BEFORE"},
356 {"type":"Text","value":" "},
357 {"type":"Keyword","value":"INSERT"},
358 {"type":"Text","value":" "},
359 {"type":"Keyword","value":"OR"},
360 {"type":"Text","value":" "},
361 {"type":"Keyword","value":"UPDATE"},
362 {"type":"Text","value":" "},
363 {"type":"Keyword","value":"ON"},
364 {"type":"Text","value":" "},
365 {"type":"Name","value":"emp"},
366 {"type":"Text","value":"\n "},
367 {"type":"Keyword","value":"FOR"},
368 {"type":"Text","value":" "},
369 {"type":"Keyword","value":"EACH"},
370 {"type":"Text","value":" "},
371 {"type":"Keyword","value":"ROW"},
372 {"type":"Text","value":" "},
373 {"type":"Keyword","value":"EXECUTE"},
374 {"type":"Text","value":" "},
375 {"type":"Keyword","value":"PROCEDURE"},
376 {"type":"Text","value":" "},
377 {"type":"Name","value":"emp_stamp"},
378 {"type":"Punctuation","value":"();"},
379 {"type":"Text","value":"\n\n"},
380 {"type":"Keyword","value":"DO"},
381 {"type":"Text","value":" "},
382 {"type":"Keyword","value":"language"},
383 {"type":"Text","value":" "},
384 {"type":"LiteralStringSingle","value":"plpgsql"},
385 {"type":"Text","value":" "},
386 {"type":"LiteralStringHeredoc","value":"$$"},
387 {"type":"TextWhitespace","value":"\n"},
388 {"type":"Keyword","value":"declare"},
389 {"type":"TextWhitespace","value":" "},
390 {"type":"Name","value":"r"},
391 {"type":"TextWhitespace","value":" "},
392 {"type":"NameBuiltin","value":"record"},
393 {"type":"Punctuation","value":";"},
394 {"type":"TextWhitespace","value":"\n"},
395 {"type":"Keyword","value":"begin"},
396 {"type":"TextWhitespace","value":"\n "},
397 {"type":"Keyword","value":"for"},
398 {"type":"TextWhitespace","value":" "},
399 {"type":"Name","value":"r"},
400 {"type":"TextWhitespace","value":" "},
401 {"type":"Keyword","value":"in"},
402 {"type":"TextWhitespace","value":" "},
403 {"type":"Keyword","value":"select"},
404 {"type":"TextWhitespace","value":" "},
405 {"type":"Operator","value":"*"},
406 {"type":"TextWhitespace","value":" "},
407 {"type":"Keyword","value":"from"},
408 {"type":"TextWhitespace","value":" "},
409 {"type":"Name","value":"books"},
410 {"type":"TextWhitespace","value":"\n"},
411 {"type":"Keyword","value":"loop"},
412 {"type":"TextWhitespace","value":"\n "},
413 {"type":"Keyword","value":"execute"},
414 {"type":"TextWhitespace","value":" "},
415 {"type":"LiteralStringSingle","value":"'select '''"},
416 {"type":"TextWhitespace","value":" "},
417 {"type":"Operator","value":"||"},
418 {"type":"TextWhitespace","value":" "},
419 {"type":"Name","value":"r"},
420 {"type":"LiteralNumberFloat","value":"."},
421 {"type":"Name","value":"title"},
422 {"type":"TextWhitespace","value":" "},
423 {"type":"Operator","value":"||"},
424 {"type":"TextWhitespace","value":" "},
425 {"type":"LiteralStringSingle","value":"''''"},
426 {"type":"Punctuation","value":";"},
427 {"type":"TextWhitespace","value":"\n"},
428 {"type":"Keyword","value":"end"},
429 {"type":"TextWhitespace","value":" "},
430 {"type":"Keyword","value":"loop"},
431 {"type":"Punctuation","value":";"},
432 {"type":"TextWhitespace","value":"\n"},
433 {"type":"Keyword","value":"end"},
434 {"type":"TextWhitespace","value":"\n"},
435 {"type":"LiteralStringHeredoc","value":"$$"},
436 {"type":"Punctuation","value":";"},
437 {"type":"Text","value":"\n\n"},
438 {"type":"Keyword","value":"DO"},
439 {"type":"Text","value":" "},
440 {"type":"LiteralStringHeredoc","value":"$$\ndeclare r record;\nbegin\n for r in select * from books\nloop\n execute 'select ''' || r.title || '''';\nend loop;\nend\n$$"},
441 {"type":"Punctuation","value":";"},
442 {"type":"Text","value":"\n"},
443 {"type":"LiteralString","value":"```"},
444 {"type":"Text","value":"\n"}
445]
View as plain text