mode-pgsql.js 73 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328
  1. ace.define("ace/mode/doc_comment_highlight_rules",["require","exports","module","ace/lib/oop","ace/mode/text_highlight_rules"], function(require, exports, module) {
  2. "use strict";
  3. var oop = require("../lib/oop");
  4. var TextHighlightRules = require("./text_highlight_rules").TextHighlightRules;
  5. var DocCommentHighlightRules = function() {
  6. this.$rules = {
  7. "start" : [ {
  8. token : "comment.doc.tag",
  9. regex : "@[\\w\\d_]+" // TODO: fix email addresses
  10. }, {
  11. token : "comment.doc.tag",
  12. regex : "\\bTODO\\b"
  13. }, {
  14. defaultToken : "comment.doc"
  15. }]
  16. };
  17. };
  18. oop.inherits(DocCommentHighlightRules, TextHighlightRules);
  19. DocCommentHighlightRules.getStartRule = function(start) {
  20. return {
  21. token : "comment.doc", // doc comment
  22. regex : "\\/\\*(?=\\*)",
  23. next : start
  24. };
  25. };
  26. DocCommentHighlightRules.getEndRule = function (start) {
  27. return {
  28. token : "comment.doc", // closing comment
  29. regex : "\\*\\/",
  30. next : start
  31. };
  32. };
  33. exports.DocCommentHighlightRules = DocCommentHighlightRules;
  34. });
  35. ace.define("ace/mode/perl_highlight_rules",["require","exports","module","ace/lib/oop","ace/mode/text_highlight_rules"], function(require, exports, module) {
  36. "use strict";
  37. var oop = require("../lib/oop");
  38. var TextHighlightRules = require("./text_highlight_rules").TextHighlightRules;
  39. var PerlHighlightRules = function() {
  40. var keywords = (
  41. "base|constant|continue|else|elsif|for|foreach|format|goto|if|last|local|my|next|" +
  42. "no|package|parent|redo|require|scalar|sub|unless|until|while|use|vars"
  43. );
  44. var buildinConstants = ("ARGV|ENV|INC|SIG");
  45. var builtinFunctions = (
  46. "getprotobynumber|getprotobyname|getservbyname|gethostbyaddr|" +
  47. "gethostbyname|getservbyport|getnetbyaddr|getnetbyname|getsockname|" +
  48. "getpeername|setpriority|getprotoent|setprotoent|getpriority|" +
  49. "endprotoent|getservent|setservent|endservent|sethostent|socketpair|" +
  50. "getsockopt|gethostent|endhostent|setsockopt|setnetent|quotemeta|" +
  51. "localtime|prototype|getnetent|endnetent|rewinddir|wantarray|getpwuid|" +
  52. "closedir|getlogin|readlink|endgrent|getgrgid|getgrnam|shmwrite|" +
  53. "shutdown|readline|endpwent|setgrent|readpipe|formline|truncate|" +
  54. "dbmclose|syswrite|setpwent|getpwnam|getgrent|getpwent|ucfirst|sysread|" +
  55. "setpgrp|shmread|sysseek|sysopen|telldir|defined|opendir|connect|" +
  56. "lcfirst|getppid|binmode|syscall|sprintf|getpgrp|readdir|seekdir|" +
  57. "waitpid|reverse|unshift|symlink|dbmopen|semget|msgrcv|rename|listen|" +
  58. "chroot|msgsnd|shmctl|accept|unpack|exists|fileno|shmget|system|" +
  59. "unlink|printf|gmtime|msgctl|semctl|values|rindex|substr|splice|" +
  60. "length|msgget|select|socket|return|caller|delete|alarm|ioctl|index|" +
  61. "undef|lstat|times|srand|chown|fcntl|close|write|umask|rmdir|study|" +
  62. "sleep|chomp|untie|print|utime|mkdir|atan2|split|crypt|flock|chmod|" +
  63. "BEGIN|bless|chdir|semop|shift|reset|link|stat|chop|grep|fork|dump|" +
  64. "join|open|tell|pipe|exit|glob|warn|each|bind|sort|pack|eval|push|" +
  65. "keys|getc|kill|seek|sqrt|send|wait|rand|tied|read|time|exec|recv|" +
  66. "eof|chr|int|ord|exp|pos|pop|sin|log|abs|oct|hex|tie|cos|vec|END|ref|" +
  67. "map|die|uc|lc|do"
  68. );
  69. var keywordMapper = this.createKeywordMapper({
  70. "keyword": keywords,
  71. "constant.language": buildinConstants,
  72. "support.function": builtinFunctions
  73. }, "identifier");
  74. this.$rules = {
  75. "start" : [
  76. {
  77. token : "comment.doc",
  78. regex : "^=(?:begin|item)\\b",
  79. next : "block_comment"
  80. }, {
  81. token : "string.regexp",
  82. regex : "[/](?:(?:\\[(?:\\\\]|[^\\]])+\\])|(?:\\\\/|[^\\]/]))*[/]\\w*\\s*(?=[).,;]|$)"
  83. }, {
  84. token : "string", // single line
  85. regex : '["](?:(?:\\\\.)|(?:[^"\\\\]))*?["]'
  86. }, {
  87. token : "string", // multi line string start
  88. regex : '["].*\\\\$',
  89. next : "qqstring"
  90. }, {
  91. token : "string", // single line
  92. regex : "['](?:(?:\\\\.)|(?:[^'\\\\]))*?[']"
  93. }, {
  94. token : "string", // multi line string start
  95. regex : "['].*\\\\$",
  96. next : "qstring"
  97. }, {
  98. token : "constant.numeric", // hex
  99. regex : "0x[0-9a-fA-F]+\\b"
  100. }, {
  101. token : "constant.numeric", // float
  102. regex : "[+-]?\\d+(?:(?:\\.\\d*)?(?:[eE][+-]?\\d+)?)?\\b"
  103. }, {
  104. token : keywordMapper,
  105. regex : "[a-zA-Z_$][a-zA-Z0-9_$]*\\b"
  106. }, {
  107. token : "keyword.operator",
  108. regex : "%#|\\$#|\\.\\.\\.|\\|\\|=|>>=|<<=|<=>|&&=|=>|!~|\\^=|&=|\\|=|\\.=|x=|%=|\\/=|\\*=|\\-=|\\+=|=~|\\*\\*|\\-\\-|\\.\\.|\\|\\||&&|\\+\\+|\\->|!=|==|>=|<=|>>|<<|,|=|\\?\\:|\\^|\\||x|%|\\/|\\*|<|&|\\\\|~|!|>|\\.|\\-|\\+|\\-C|\\-b|\\-S|\\-u|\\-t|\\-p|\\-l|\\-d|\\-f|\\-g|\\-s|\\-z|\\-k|\\-e|\\-O|\\-T|\\-B|\\-M|\\-A|\\-X|\\-W|\\-c|\\-R|\\-o|\\-x|\\-w|\\-r|\\b(?:and|cmp|eq|ge|gt|le|lt|ne|not|or|xor)"
  109. }, {
  110. token : "comment",
  111. regex : "#.*$"
  112. }, {
  113. token : "lparen",
  114. regex : "[[({]"
  115. }, {
  116. token : "rparen",
  117. regex : "[\\])}]"
  118. }, {
  119. token : "text",
  120. regex : "\\s+"
  121. }
  122. ],
  123. "qqstring" : [
  124. {
  125. token : "string",
  126. regex : '(?:(?:\\\\.)|(?:[^"\\\\]))*?"',
  127. next : "start"
  128. }, {
  129. token : "string",
  130. regex : '.+'
  131. }
  132. ],
  133. "qstring" : [
  134. {
  135. token : "string",
  136. regex : "(?:(?:\\\\.)|(?:[^'\\\\]))*?'",
  137. next : "start"
  138. }, {
  139. token : "string",
  140. regex : '.+'
  141. }
  142. ],
  143. "block_comment": [
  144. {
  145. token: "comment.doc",
  146. regex: "^=cut\\b",
  147. next: "start"
  148. },
  149. {
  150. defaultToken: "comment.doc"
  151. }
  152. ]
  153. };
  154. };
  155. oop.inherits(PerlHighlightRules, TextHighlightRules);
  156. exports.PerlHighlightRules = PerlHighlightRules;
  157. });
  158. ace.define("ace/mode/python_highlight_rules",["require","exports","module","ace/lib/oop","ace/mode/text_highlight_rules"], function(require, exports, module) {
  159. "use strict";
  160. var oop = require("../lib/oop");
  161. var TextHighlightRules = require("./text_highlight_rules").TextHighlightRules;
  162. var PythonHighlightRules = function() {
  163. var keywords = (
  164. "and|as|assert|break|class|continue|def|del|elif|else|except|exec|" +
  165. "finally|for|from|global|if|import|in|is|lambda|not|or|pass|print|" +
  166. "raise|return|try|while|with|yield"
  167. );
  168. var builtinConstants = (
  169. "True|False|None|NotImplemented|Ellipsis|__debug__"
  170. );
  171. var builtinFunctions = (
  172. "abs|divmod|input|open|staticmethod|all|enumerate|int|ord|str|any|" +
  173. "eval|isinstance|pow|sum|basestring|execfile|issubclass|print|super|" +
  174. "binfile|iter|property|tuple|bool|filter|len|range|type|bytearray|" +
  175. "float|list|raw_input|unichr|callable|format|locals|reduce|unicode|" +
  176. "chr|frozenset|long|reload|vars|classmethod|getattr|map|repr|xrange|" +
  177. "cmp|globals|max|reversed|zip|compile|hasattr|memoryview|round|" +
  178. "__import__|complex|hash|min|set|apply|delattr|help|next|setattr|" +
  179. "buffer|dict|hex|object|slice|coerce|dir|id|oct|sorted|intern"
  180. );
  181. var keywordMapper = this.createKeywordMapper({
  182. "invalid.deprecated": "debugger",
  183. "support.function": builtinFunctions,
  184. "constant.language": builtinConstants,
  185. "keyword": keywords
  186. }, "identifier");
  187. var strPre = "(?:r|u|ur|R|U|UR|Ur|uR)?";
  188. var decimalInteger = "(?:(?:[1-9]\\d*)|(?:0))";
  189. var octInteger = "(?:0[oO]?[0-7]+)";
  190. var hexInteger = "(?:0[xX][\\dA-Fa-f]+)";
  191. var binInteger = "(?:0[bB][01]+)";
  192. var integer = "(?:" + decimalInteger + "|" + octInteger + "|" + hexInteger + "|" + binInteger + ")";
  193. var exponent = "(?:[eE][+-]?\\d+)";
  194. var fraction = "(?:\\.\\d+)";
  195. var intPart = "(?:\\d+)";
  196. var pointFloat = "(?:(?:" + intPart + "?" + fraction + ")|(?:" + intPart + "\\.))";
  197. var exponentFloat = "(?:(?:" + pointFloat + "|" + intPart + ")" + exponent + ")";
  198. var floatNumber = "(?:" + exponentFloat + "|" + pointFloat + ")";
  199. var stringEscape = "\\\\(x[0-9A-Fa-f]{2}|[0-7]{3}|[\\\\abfnrtv'\"]|U[0-9A-Fa-f]{8}|u[0-9A-Fa-f]{4})";
  200. this.$rules = {
  201. "start" : [ {
  202. token : "comment",
  203. regex : "#.*$"
  204. }, {
  205. token : "string", // multi line """ string start
  206. regex : strPre + '"{3}',
  207. next : "qqstring3"
  208. }, {
  209. token : "string", // " string
  210. regex : strPre + '"(?=.)',
  211. next : "qqstring"
  212. }, {
  213. token : "string", // multi line ''' string start
  214. regex : strPre + "'{3}",
  215. next : "qstring3"
  216. }, {
  217. token : "string", // ' string
  218. regex : strPre + "'(?=.)",
  219. next : "qstring"
  220. }, {
  221. token : "constant.numeric", // imaginary
  222. regex : "(?:" + floatNumber + "|\\d+)[jJ]\\b"
  223. }, {
  224. token : "constant.numeric", // float
  225. regex : floatNumber
  226. }, {
  227. token : "constant.numeric", // long integer
  228. regex : integer + "[lL]\\b"
  229. }, {
  230. token : "constant.numeric", // integer
  231. regex : integer + "\\b"
  232. }, {
  233. token : keywordMapper,
  234. regex : "[a-zA-Z_$][a-zA-Z0-9_$]*\\b"
  235. }, {
  236. token : "keyword.operator",
  237. regex : "\\+|\\-|\\*|\\*\\*|\\/|\\/\\/|%|<<|>>|&|\\||\\^|~|<|>|<=|=>|==|!=|<>|="
  238. }, {
  239. token : "paren.lparen",
  240. regex : "[\\[\\(\\{]"
  241. }, {
  242. token : "paren.rparen",
  243. regex : "[\\]\\)\\}]"
  244. }, {
  245. token : "text",
  246. regex : "\\s+"
  247. } ],
  248. "qqstring3" : [ {
  249. token : "constant.language.escape",
  250. regex : stringEscape
  251. }, {
  252. token : "string", // multi line """ string end
  253. regex : '"{3}',
  254. next : "start"
  255. }, {
  256. defaultToken : "string"
  257. } ],
  258. "qstring3" : [ {
  259. token : "constant.language.escape",
  260. regex : stringEscape
  261. }, {
  262. token : "string", // multi line ''' string end
  263. regex : "'{3}",
  264. next : "start"
  265. }, {
  266. defaultToken : "string"
  267. } ],
  268. "qqstring" : [{
  269. token : "constant.language.escape",
  270. regex : stringEscape
  271. }, {
  272. token : "string",
  273. regex : "\\\\$",
  274. next : "qqstring"
  275. }, {
  276. token : "string",
  277. regex : '"|$',
  278. next : "start"
  279. }, {
  280. defaultToken: "string"
  281. }],
  282. "qstring" : [{
  283. token : "constant.language.escape",
  284. regex : stringEscape
  285. }, {
  286. token : "string",
  287. regex : "\\\\$",
  288. next : "qstring"
  289. }, {
  290. token : "string",
  291. regex : "'|$",
  292. next : "start"
  293. }, {
  294. defaultToken: "string"
  295. }]
  296. };
  297. };
  298. oop.inherits(PythonHighlightRules, TextHighlightRules);
  299. exports.PythonHighlightRules = PythonHighlightRules;
  300. });
  301. ace.define("ace/mode/json_highlight_rules",["require","exports","module","ace/lib/oop","ace/mode/text_highlight_rules"], function(require, exports, module) {
  302. "use strict";
  303. var oop = require("../lib/oop");
  304. var TextHighlightRules = require("./text_highlight_rules").TextHighlightRules;
  305. var JsonHighlightRules = function() {
  306. this.$rules = {
  307. "start" : [
  308. {
  309. token : "variable", // single line
  310. regex : '["](?:(?:\\\\.)|(?:[^"\\\\]))*?["]\\s*(?=:)'
  311. }, {
  312. token : "string", // single line
  313. regex : '"',
  314. next : "string"
  315. }, {
  316. token : "constant.numeric", // hex
  317. regex : "0[xX][0-9a-fA-F]+\\b"
  318. }, {
  319. token : "constant.numeric", // float
  320. regex : "[+-]?\\d+(?:(?:\\.\\d*)?(?:[eE][+-]?\\d+)?)?\\b"
  321. }, {
  322. token : "constant.language.boolean",
  323. regex : "(?:true|false)\\b"
  324. }, {
  325. token : "invalid.illegal", // single quoted strings are not allowed
  326. regex : "['](?:(?:\\\\.)|(?:[^'\\\\]))*?[']"
  327. }, {
  328. token : "invalid.illegal", // comments are not allowed
  329. regex : "\\/\\/.*$"
  330. }, {
  331. token : "paren.lparen",
  332. regex : "[[({]"
  333. }, {
  334. token : "paren.rparen",
  335. regex : "[\\])}]"
  336. }, {
  337. token : "text",
  338. regex : "\\s+"
  339. }
  340. ],
  341. "string" : [
  342. {
  343. token : "constant.language.escape",
  344. regex : /\\(?:x[0-9a-fA-F]{2}|u[0-9a-fA-F]{4}|["\\\/bfnrt])/
  345. }, {
  346. token : "string",
  347. regex : '[^"\\\\]+'
  348. }, {
  349. token : "string",
  350. regex : '"',
  351. next : "start"
  352. }, {
  353. token : "string",
  354. regex : "",
  355. next : "start"
  356. }
  357. ]
  358. };
  359. };
  360. oop.inherits(JsonHighlightRules, TextHighlightRules);
  361. exports.JsonHighlightRules = JsonHighlightRules;
  362. });
  363. ace.define("ace/mode/javascript_highlight_rules",["require","exports","module","ace/lib/oop","ace/mode/doc_comment_highlight_rules","ace/mode/text_highlight_rules"], function(require, exports, module) {
  364. "use strict";
  365. var oop = require("../lib/oop");
  366. var DocCommentHighlightRules = require("./doc_comment_highlight_rules").DocCommentHighlightRules;
  367. var TextHighlightRules = require("./text_highlight_rules").TextHighlightRules;
  368. var JavaScriptHighlightRules = function() {
  369. var keywordMapper = this.createKeywordMapper({
  370. "variable.language":
  371. "Array|Boolean|Date|Function|Iterator|Number|Object|RegExp|String|Proxy|" + // Constructors
  372. "Namespace|QName|XML|XMLList|" + // E4X
  373. "ArrayBuffer|Float32Array|Float64Array|Int16Array|Int32Array|Int8Array|" +
  374. "Uint16Array|Uint32Array|Uint8Array|Uint8ClampedArray|" +
  375. "Error|EvalError|InternalError|RangeError|ReferenceError|StopIteration|" + // Errors
  376. "SyntaxError|TypeError|URIError|" +
  377. "decodeURI|decodeURIComponent|encodeURI|encodeURIComponent|eval|isFinite|" + // Non-constructor functions
  378. "isNaN|parseFloat|parseInt|" +
  379. "JSON|Math|" + // Other
  380. "this|arguments|prototype|window|document" , // Pseudo
  381. "keyword":
  382. "const|yield|import|get|set|" +
  383. "break|case|catch|continue|default|delete|do|else|finally|for|function|" +
  384. "if|in|instanceof|new|return|switch|throw|try|typeof|let|var|while|with|debugger|" +
  385. "__parent__|__count__|escape|unescape|with|__proto__|" +
  386. "class|enum|extends|super|export|implements|private|public|interface|package|protected|static",
  387. "storage.type":
  388. "const|let|var|function",
  389. "constant.language":
  390. "null|Infinity|NaN|undefined",
  391. "support.function":
  392. "alert",
  393. "constant.language.boolean": "true|false"
  394. }, "identifier");
  395. var kwBeforeRe = "case|do|else|finally|in|instanceof|return|throw|try|typeof|yield|void";
  396. var identifierRe = "[a-zA-Z\\$_\u00a1-\uffff][a-zA-Z\\d\\$_\u00a1-\uffff]*\\b";
  397. var escapedRe = "\\\\(?:x[0-9a-fA-F]{2}|" + // hex
  398. "u[0-9a-fA-F]{4}|" + // unicode
  399. "[0-2][0-7]{0,2}|" + // oct
  400. "3[0-6][0-7]?|" + // oct
  401. "37[0-7]?|" + // oct
  402. "[4-7][0-7]?|" + //oct
  403. ".)";
  404. this.$rules = {
  405. "no_regex" : [
  406. {
  407. token : "comment",
  408. regex : "\\/\\/",
  409. next : "line_comment"
  410. },
  411. DocCommentHighlightRules.getStartRule("doc-start"),
  412. {
  413. token : "comment", // multi line comment
  414. regex : /\/\*/,
  415. next : "comment"
  416. }, {
  417. token : "string",
  418. regex : "'(?=.)",
  419. next : "qstring"
  420. }, {
  421. token : "string",
  422. regex : '"(?=.)',
  423. next : "qqstring"
  424. }, {
  425. token : "constant.numeric", // hex
  426. regex : /0[xX][0-9a-fA-F]+\b/
  427. }, {
  428. token : "constant.numeric", // float
  429. regex : /[+-]?\d+(?:(?:\.\d*)?(?:[eE][+-]?\d+)?)?\b/
  430. }, {
  431. token : [
  432. "storage.type", "punctuation.operator", "support.function",
  433. "punctuation.operator", "entity.name.function", "text","keyword.operator"
  434. ],
  435. regex : "(" + identifierRe + ")(\\.)(prototype)(\\.)(" + identifierRe +")(\\s*)(=)",
  436. next: "function_arguments"
  437. }, {
  438. token : [
  439. "storage.type", "punctuation.operator", "entity.name.function", "text",
  440. "keyword.operator", "text", "storage.type", "text", "paren.lparen"
  441. ],
  442. regex : "(" + identifierRe + ")(\\.)(" + identifierRe +")(\\s*)(=)(\\s*)(function)(\\s*)(\\()",
  443. next: "function_arguments"
  444. }, {
  445. token : [
  446. "entity.name.function", "text", "keyword.operator", "text", "storage.type",
  447. "text", "paren.lparen"
  448. ],
  449. regex : "(" + identifierRe +")(\\s*)(=)(\\s*)(function)(\\s*)(\\()",
  450. next: "function_arguments"
  451. }, {
  452. token : [
  453. "storage.type", "punctuation.operator", "entity.name.function", "text",
  454. "keyword.operator", "text",
  455. "storage.type", "text", "entity.name.function", "text", "paren.lparen"
  456. ],
  457. regex : "(" + identifierRe + ")(\\.)(" + identifierRe +")(\\s*)(=)(\\s*)(function)(\\s+)(\\w+)(\\s*)(\\()",
  458. next: "function_arguments"
  459. }, {
  460. token : [
  461. "storage.type", "text", "entity.name.function", "text", "paren.lparen"
  462. ],
  463. regex : "(function)(\\s+)(" + identifierRe + ")(\\s*)(\\()",
  464. next: "function_arguments"
  465. }, {
  466. token : [
  467. "entity.name.function", "text", "punctuation.operator",
  468. "text", "storage.type", "text", "paren.lparen"
  469. ],
  470. regex : "(" + identifierRe + ")(\\s*)(:)(\\s*)(function)(\\s*)(\\()",
  471. next: "function_arguments"
  472. }, {
  473. token : [
  474. "text", "text", "storage.type", "text", "paren.lparen"
  475. ],
  476. regex : "(:)(\\s*)(function)(\\s*)(\\()",
  477. next: "function_arguments"
  478. }, {
  479. token : "keyword",
  480. regex : "(?:" + kwBeforeRe + ")\\b",
  481. next : "start"
  482. }, {
  483. token : ["punctuation.operator", "support.function"],
  484. regex : /(\.)(s(?:h(?:ift|ow(?:Mod(?:elessDialog|alDialog)|Help))|croll(?:X|By(?:Pages|Lines)?|Y|To)?|t(?:op|rike)|i(?:n|zeToContent|debar|gnText)|ort|u(?:p|b(?:str(?:ing)?)?)|pli(?:ce|t)|e(?:nd|t(?:Re(?:sizable|questHeader)|M(?:i(?:nutes|lliseconds)|onth)|Seconds|Ho(?:tKeys|urs)|Year|Cursor|Time(?:out)?|Interval|ZOptions|Date|UTC(?:M(?:i(?:nutes|lliseconds)|onth)|Seconds|Hours|Date|FullYear)|FullYear|Active)|arch)|qrt|lice|avePreferences|mall)|h(?:ome|andleEvent)|navigate|c(?:har(?:CodeAt|At)|o(?:s|n(?:cat|textual|firm)|mpile)|eil|lear(?:Timeout|Interval)?|a(?:ptureEvents|ll)|reate(?:StyleSheet|Popup|EventObject))|t(?:o(?:GMTString|S(?:tring|ource)|U(?:TCString|pperCase)|Lo(?:caleString|werCase))|est|a(?:n|int(?:Enabled)?))|i(?:s(?:NaN|Finite)|ndexOf|talics)|d(?:isableExternalCapture|ump|etachEvent)|u(?:n(?:shift|taint|escape|watch)|pdateCommands)|j(?:oin|avaEnabled)|p(?:o(?:p|w)|ush|lugins.refresh|a(?:ddings|rse(?:Int|Float)?)|r(?:int|ompt|eference))|e(?:scape|nableExternalCapture|val|lementFromPoint|x(?:p|ec(?:Script|Command)?))|valueOf|UTC|queryCommand(?:State|Indeterm|Enabled|Value)|f(?:i(?:nd|le(?:ModifiedDate|Size|CreatedDate|UpdatedDate)|xed)|o(?:nt(?:size|color)|rward)|loor|romCharCode)|watch|l(?:ink|o(?:ad|g)|astIndexOf)|a(?:sin|nchor|cos|t(?:tachEvent|ob|an(?:2)?)|pply|lert|b(?:s|ort))|r(?:ou(?:nd|teEvents)|e(?:size(?:By|To)|calc|turnValue|place|verse|l(?:oad|ease(?:Capture|Events)))|andom)|g(?:o|et(?:ResponseHeader|M(?:i(?:nutes|lliseconds)|onth)|Se(?:conds|lection)|Hours|Year|Time(?:zoneOffset)?|Da(?:y|te)|UTC(?:M(?:i(?:nutes|lliseconds)|onth)|Seconds|Hours|Da(?:y|te)|FullYear)|FullYear|A(?:ttention|llResponseHeaders)))|m(?:in|ove(?:B(?:y|elow)|To(?:Absolute)?|Above)|ergeAttributes|a(?:tch|rgins|x))|b(?:toa|ig|o(?:ld|rderWidths)|link|ack))\b(?=\()/
  485. }, {
  486. token : ["punctuation.operator", "support.function.dom"],
  487. regex : /(\.)(s(?:ub(?:stringData|mit)|plitText|e(?:t(?:NamedItem|Attribute(?:Node)?)|lect))|has(?:ChildNodes|Feature)|namedItem|c(?:l(?:ick|o(?:se|neNode))|reate(?:C(?:omment|DATASection|aption)|T(?:Head|extNode|Foot)|DocumentFragment|ProcessingInstruction|E(?:ntityReference|lement)|Attribute))|tabIndex|i(?:nsert(?:Row|Before|Cell|Data)|tem)|open|delete(?:Row|C(?:ell|aption)|T(?:Head|Foot)|Data)|focus|write(?:ln)?|a(?:dd|ppend(?:Child|Data))|re(?:set|place(?:Child|Data)|move(?:NamedItem|Child|Attribute(?:Node)?)?)|get(?:NamedItem|Element(?:sBy(?:Name|TagName)|ById)|Attribute(?:Node)?)|blur)\b(?=\()/
  488. }, {
  489. token : ["punctuation.operator", "support.constant"],
  490. regex : /(\.)(s(?:ystemLanguage|cr(?:ipts|ollbars|een(?:X|Y|Top|Left))|t(?:yle(?:Sheets)?|atus(?:Text|bar)?)|ibling(?:Below|Above)|ource|uffixes|e(?:curity(?:Policy)?|l(?:ection|f)))|h(?:istory|ost(?:name)?|as(?:h|Focus))|y|X(?:MLDocument|SLDocument)|n(?:ext|ame(?:space(?:s|URI)|Prop))|M(?:IN_VALUE|AX_VALUE)|c(?:haracterSet|o(?:n(?:structor|trollers)|okieEnabled|lorDepth|mp(?:onents|lete))|urrent|puClass|l(?:i(?:p(?:boardData)?|entInformation)|osed|asses)|alle(?:e|r)|rypto)|t(?:o(?:olbar|p)|ext(?:Transform|Indent|Decoration|Align)|ags)|SQRT(?:1_2|2)|i(?:n(?:ner(?:Height|Width)|put)|ds|gnoreCase)|zIndex|o(?:scpu|n(?:readystatechange|Line)|uter(?:Height|Width)|p(?:sProfile|ener)|ffscreenBuffering)|NEGATIVE_INFINITY|d(?:i(?:splay|alog(?:Height|Top|Width|Left|Arguments)|rectories)|e(?:scription|fault(?:Status|Ch(?:ecked|arset)|View)))|u(?:ser(?:Profile|Language|Agent)|n(?:iqueID|defined)|pdateInterval)|_content|p(?:ixelDepth|ort|ersonalbar|kcs11|l(?:ugins|atform)|a(?:thname|dding(?:Right|Bottom|Top|Left)|rent(?:Window|Layer)?|ge(?:X(?:Offset)?|Y(?:Offset)?))|r(?:o(?:to(?:col|type)|duct(?:Sub)?|mpter)|e(?:vious|fix)))|e(?:n(?:coding|abledPlugin)|x(?:ternal|pando)|mbeds)|v(?:isibility|endor(?:Sub)?|Linkcolor)|URLUnencoded|P(?:I|OSITIVE_INFINITY)|f(?:ilename|o(?:nt(?:Size|Family|Weight)|rmName)|rame(?:s|Element)|gColor)|E|whiteSpace|l(?:i(?:stStyleType|n(?:eHeight|kColor))|o(?:ca(?:tion(?:bar)?|lName)|wsrc)|e(?:ngth|ft(?:Context)?)|a(?:st(?:M(?:odified|atch)|Index|Paren)|yer(?:s|X)|nguage))|a(?:pp(?:MinorVersion|Name|Co(?:deName|re)|Version)|vail(?:Height|Top|Width|Left)|ll|r(?:ity|guments)|Linkcolor|bove)|r(?:ight(?:Context)?|e(?:sponse(?:XML|Text)|adyState))|global|x|m(?:imeTypes|ultiline|enubar|argin(?:Right|Bottom|Top|Left))|L(?:N(?:10|2)|OG(?:10E|2E))|b(?:o(?:ttom|rder(?:Width|RightWidth|BottomWidth|Style|Color|TopWidth|LeftWidth))|ufferDepth|elow|ackground(?:Color|Image)))\b/
  491. }, {
  492. token : ["support.constant"],
  493. regex : /that\b/
  494. }, {
  495. token : ["storage.type", "punctuation.operator", "support.function.firebug"],
  496. regex : /(console)(\.)(warn|info|log|error|time|trace|timeEnd|assert)\b/
  497. }, {
  498. token : keywordMapper,
  499. regex : identifierRe
  500. }, {
  501. token : "keyword.operator",
  502. regex : /--|\+\+|[!$%&*+\-~]|===|==|=|!=|!==|<=|>=|<<=|>>=|>>>=|<>|<|>|!|&&|\|\||\?\:|\*=|%=|\+=|\-=|&=|\^=/,
  503. next : "start"
  504. }, {
  505. token : "punctuation.operator",
  506. regex : /\?|\:|\,|\;|\./,
  507. next : "start"
  508. }, {
  509. token : "paren.lparen",
  510. regex : /[\[({]/,
  511. next : "start"
  512. }, {
  513. token : "paren.rparen",
  514. regex : /[\])}]/
  515. }, {
  516. token : "keyword.operator",
  517. regex : /\/=?/,
  518. next : "start"
  519. }, {
  520. token: "comment",
  521. regex: /^#!.*$/
  522. }
  523. ],
  524. "start": [
  525. DocCommentHighlightRules.getStartRule("doc-start"),
  526. {
  527. token : "comment", // multi line comment
  528. regex : "\\/\\*",
  529. next : "comment_regex_allowed"
  530. }, {
  531. token : "comment",
  532. regex : "\\/\\/",
  533. next : "line_comment_regex_allowed"
  534. }, {
  535. token: "string.regexp",
  536. regex: "\\/",
  537. next: "regex"
  538. }, {
  539. token : "text",
  540. regex : "\\s+|^$",
  541. next : "start"
  542. }, {
  543. token: "empty",
  544. regex: "",
  545. next: "no_regex"
  546. }
  547. ],
  548. "regex": [
  549. {
  550. token: "regexp.keyword.operator",
  551. regex: "\\\\(?:u[\\da-fA-F]{4}|x[\\da-fA-F]{2}|.)"
  552. }, {
  553. token: "string.regexp",
  554. regex: "/[sxngimy]*",
  555. next: "no_regex"
  556. }, {
  557. token : "invalid",
  558. regex: /\{\d+\b,?\d*\}[+*]|[+*$^?][+*]|[$^][?]|\?{3,}/
  559. }, {
  560. token : "constant.language.escape",
  561. regex: /\(\?[:=!]|\)|\{\d+\b,?\d*\}|[+*]\?|[()$^+*?.]/
  562. }, {
  563. token : "constant.language.delimiter",
  564. regex: /\|/
  565. }, {
  566. token: "constant.language.escape",
  567. regex: /\[\^?/,
  568. next: "regex_character_class"
  569. }, {
  570. token: "empty",
  571. regex: "$",
  572. next: "no_regex"
  573. }, {
  574. defaultToken: "string.regexp"
  575. }
  576. ],
  577. "regex_character_class": [
  578. {
  579. token: "regexp.keyword.operator",
  580. regex: "\\\\(?:u[\\da-fA-F]{4}|x[\\da-fA-F]{2}|.)"
  581. }, {
  582. token: "constant.language.escape",
  583. regex: "]",
  584. next: "regex"
  585. }, {
  586. token: "constant.language.escape",
  587. regex: "-"
  588. }, {
  589. token: "empty",
  590. regex: "$",
  591. next: "no_regex"
  592. }, {
  593. defaultToken: "string.regexp.charachterclass"
  594. }
  595. ],
  596. "function_arguments": [
  597. {
  598. token: "variable.parameter",
  599. regex: identifierRe
  600. }, {
  601. token: "punctuation.operator",
  602. regex: "[, ]+"
  603. }, {
  604. token: "punctuation.operator",
  605. regex: "$"
  606. }, {
  607. token: "empty",
  608. regex: "",
  609. next: "no_regex"
  610. }
  611. ],
  612. "comment_regex_allowed" : [
  613. {token : "comment", regex : "\\*\\/", next : "start"},
  614. {defaultToken : "comment"}
  615. ],
  616. "comment" : [
  617. {token : "comment", regex : "\\*\\/", next : "no_regex"},
  618. {defaultToken : "comment"}
  619. ],
  620. "line_comment_regex_allowed" : [
  621. {token : "comment", regex : "$|^", next : "start"},
  622. {defaultToken : "comment"}
  623. ],
  624. "line_comment" : [
  625. {token : "comment", regex : "$|^", next : "no_regex"},
  626. {defaultToken : "comment"}
  627. ],
  628. "qqstring" : [
  629. {
  630. token : "constant.language.escape",
  631. regex : escapedRe
  632. }, {
  633. token : "string",
  634. regex : "\\\\$",
  635. next : "qqstring"
  636. }, {
  637. token : "string",
  638. regex : '"|$',
  639. next : "no_regex"
  640. }, {
  641. defaultToken: "string"
  642. }
  643. ],
  644. "qstring" : [
  645. {
  646. token : "constant.language.escape",
  647. regex : escapedRe
  648. }, {
  649. token : "string",
  650. regex : "\\\\$",
  651. next : "qstring"
  652. }, {
  653. token : "string",
  654. regex : "'|$",
  655. next : "no_regex"
  656. }, {
  657. defaultToken: "string"
  658. }
  659. ]
  660. };
  661. this.embedRules(DocCommentHighlightRules, "doc-",
  662. [ DocCommentHighlightRules.getEndRule("no_regex") ]);
  663. };
  664. oop.inherits(JavaScriptHighlightRules, TextHighlightRules);
  665. exports.JavaScriptHighlightRules = JavaScriptHighlightRules;
  666. });
  667. ace.define("ace/mode/pgsql_highlight_rules",["require","exports","module","ace/lib/oop","ace/lib/lang","ace/mode/doc_comment_highlight_rules","ace/mode/text_highlight_rules","ace/mode/perl_highlight_rules","ace/mode/python_highlight_rules","ace/mode/json_highlight_rules","ace/mode/javascript_highlight_rules"], function(require, exports, module) {
  668. var oop = require("../lib/oop");
  669. var lang = require("../lib/lang");
  670. var DocCommentHighlightRules = require("./doc_comment_highlight_rules").DocCommentHighlightRules;
  671. var TextHighlightRules = require("./text_highlight_rules").TextHighlightRules;
  672. var PerlHighlightRules = require("./perl_highlight_rules").PerlHighlightRules;
  673. var PythonHighlightRules = require("./python_highlight_rules").PythonHighlightRules;
  674. var JsonHighlightRules = require("./json_highlight_rules").JsonHighlightRules;
  675. var JavaScriptHighlightRules = require("./javascript_highlight_rules").JavaScriptHighlightRules;
  676. var PgsqlHighlightRules = function() {
  677. var keywords = (
  678. "abort|absolute|abstime|access|aclitem|action|add|admin|after|aggregate|all|also|alter|always|" +
  679. "analyse|analyze|and|any|anyarray|anyelement|anyenum|anynonarray|anyrange|array|as|asc|" +
  680. "assertion|assignment|asymmetric|at|attribute|authorization|backward|before|begin|between|" +
  681. "bigint|binary|bit|bool|boolean|both|box|bpchar|by|bytea|cache|called|cascade|cascaded|case|cast|" +
  682. "catalog|chain|char|character|characteristics|check|checkpoint|cid|cidr|circle|class|close|" +
  683. "cluster|coalesce|collate|collation|column|comment|comments|commit|committed|concurrently|" +
  684. "configuration|connection|constraint|constraints|content|continue|conversion|copy|cost|" +
  685. "create|cross|cstring|csv|current|current_catalog|current_date|current_role|" +
  686. "current_schema|current_time|current_timestamp|current_user|cursor|cycle|data|database|" +
  687. "date|daterange|day|deallocate|dec|decimal|declare|default|defaults|deferrable|deferred|" +
  688. "definer|delete|delimiter|delimiters|desc|dictionary|disable|discard|distinct|do|document|" +
  689. "domain|double|drop|each|else|enable|encoding|encrypted|end|enum|escape|event|event_trigger|" +
  690. "except|exclude|excluding|exclusive|execute|exists|explain|extension|external|extract|false|" +
  691. "family|fdw_handler|fetch|first|float|float4|float8|following|for|force|foreign|forward|" +
  692. "freeze|from|full|function|functions|global|grant|granted|greatest|group|gtsvector|handler|" +
  693. "having|header|hold|hour|identity|if|ilike|immediate|immutable|implicit|in|including|" +
  694. "increment|index|indexes|inet|inherit|inherits|initially|inline|inner|inout|input|" +
  695. "insensitive|insert|instead|int|int2|int2vector|int4|int4range|int8|int8range|integer|" +
  696. "internal|intersect|interval|into|invoker|is|isnull|isolation|join|json|key|label|language|" +
  697. "language_handler|large|last|lateral|lc_collate|lc_ctype|leading|leakproof|least|left|level|" +
  698. "like|limit|line|listen|load|local|localtime|localtimestamp|location|lock|lseg|macaddr|" +
  699. "mapping|match|materialized|maxvalue|minute|minvalue|mode|money|month|move|name|names|" +
  700. "national|natural|nchar|next|no|none|not|nothing|notify|notnull|nowait|null|nullif|nulls|" +
  701. "numeric|numrange|object|of|off|offset|oid|oids|oidvector|on|only|opaque|operator|option|" +
  702. "options|or|order|out|outer|over|overlaps|overlay|owned|owner|parser|partial|partition|passing|" +
  703. "password|path|pg_attribute|pg_auth_members|pg_authid|pg_class|pg_database|pg_node_tree|" +
  704. "pg_proc|pg_type|placing|plans|point|polygon|position|preceding|precision|prepare|prepared|" +
  705. "preserve|primary|prior|privileges|procedural|procedure|program|quote|range|read|real|" +
  706. "reassign|recheck|record|recursive|ref|refcursor|references|refresh|regclass|regconfig|" +
  707. "regdictionary|regoper|regoperator|regproc|regprocedure|regtype|reindex|relative|release|" +
  708. "reltime|rename|repeatable|replace|replica|reset|restart|restrict|returning|returns|revoke|" +
  709. "right|role|rollback|row|rows|rule|savepoint|schema|scroll|search|second|security|select|" +
  710. "sequence|sequences|serializable|server|session|session_user|set|setof|share|show|similar|" +
  711. "simple|smallint|smgr|snapshot|some|stable|standalone|start|statement|statistics|stdin|" +
  712. "stdout|storage|strict|strip|substring|symmetric|sysid|system|table|tables|tablespace|temp|" +
  713. "template|temporary|text|then|tid|time|timestamp|timestamptz|timetz|tinterval|to|trailing|" +
  714. "transaction|treat|trigger|trim|true|truncate|trusted|tsquery|tsrange|tstzrange|tsvector|" +
  715. "txid_snapshot|type|types|unbounded|uncommitted|unencrypted|union|unique|unknown|unlisten|" +
  716. "unlogged|until|update|user|using|uuid|vacuum|valid|validate|validator|value|values|varbit|" +
  717. "varchar|variadic|varying|verbose|version|view|void|volatile|when|where|whitespace|window|" +
  718. "with|without|work|wrapper|write|xid|xml|xmlattributes|xmlconcat|xmlelement|xmlexists|" +
  719. "xmlforest|xmlparse|xmlpi|xmlroot|xmlserialize|year|yes|zone"
  720. );
  721. var builtinFunctions = (
  722. "RI_FKey_cascade_del|RI_FKey_cascade_upd|RI_FKey_check_ins|RI_FKey_check_upd|" +
  723. "RI_FKey_noaction_del|RI_FKey_noaction_upd|RI_FKey_restrict_del|RI_FKey_restrict_upd|" +
  724. "RI_FKey_setdefault_del|RI_FKey_setdefault_upd|RI_FKey_setnull_del|" +
  725. "RI_FKey_setnull_upd|abbrev|abs|abstime|abstimeeq|abstimege|abstimegt|abstimein|abstimele|" +
  726. "abstimelt|abstimene|abstimeout|abstimerecv|abstimesend|aclcontains|acldefault|" +
  727. "aclexplode|aclinsert|aclitemeq|aclitemin|aclitemout|aclremove|acos|age|any_in|any_out|" +
  728. "anyarray_in|anyarray_out|anyarray_recv|anyarray_send|anyelement_in|anyelement_out|" +
  729. "anyenum_in|anyenum_out|anynonarray_in|anynonarray_out|anyrange_in|anyrange_out|" +
  730. "anytextcat|area|areajoinsel|areasel|array_agg|array_agg_finalfn|array_agg_transfn|" +
  731. "array_append|array_cat|array_dims|array_eq|array_fill|array_ge|array_gt|array_in|" +
  732. "array_larger|array_le|array_length|array_lower|array_lt|array_ndims|array_ne|array_out|" +
  733. "array_prepend|array_recv|array_remove|array_replace|array_send|array_smaller|" +
  734. "array_to_json|array_to_string|array_typanalyze|array_upper|arraycontained|" +
  735. "arraycontains|arraycontjoinsel|arraycontsel|arrayoverlap|ascii|ascii_to_mic|" +
  736. "ascii_to_utf8|asin|atan|atan2|avg|big5_to_euc_tw|big5_to_mic|big5_to_utf8|bit_and|bit_in|" +
  737. "bit_length|bit_or|bit_out|bit_recv|bit_send|bitand|bitcat|bitcmp|biteq|bitge|bitgt|bitle|" +
  738. "bitlt|bitne|bitnot|bitor|bitshiftleft|bitshiftright|bittypmodin|bittypmodout|bitxor|bool|" +
  739. "bool_and|bool_or|booland_statefunc|booleq|boolge|boolgt|boolin|boolle|boollt|boolne|" +
  740. "boolor_statefunc|boolout|boolrecv|boolsend|box|box_above|box_above_eq|box_add|box_below|" +
  741. "box_below_eq|box_center|box_contain|box_contain_pt|box_contained|box_distance|box_div|" +
  742. "box_eq|box_ge|box_gt|box_in|box_intersect|box_le|box_left|box_lt|box_mul|box_out|" +
  743. "box_overabove|box_overbelow|box_overlap|box_overleft|box_overright|box_recv|box_right|" +
  744. "box_same|box_send|box_sub|bpchar_larger|bpchar_pattern_ge|bpchar_pattern_gt|" +
  745. "bpchar_pattern_le|bpchar_pattern_lt|bpchar_smaller|bpcharcmp|bpchareq|bpcharge|" +
  746. "bpchargt|bpchariclike|bpcharicnlike|bpcharicregexeq|bpcharicregexne|bpcharin|bpcharle|" +
  747. "bpcharlike|bpcharlt|bpcharne|bpcharnlike|bpcharout|bpcharrecv|bpcharregexeq|" +
  748. "bpcharregexne|bpcharsend|bpchartypmodin|bpchartypmodout|broadcast|btabstimecmp|" +
  749. "btarraycmp|btbeginscan|btboolcmp|btbpchar_pattern_cmp|btbuild|btbuildempty|" +
  750. "btbulkdelete|btcanreturn|btcharcmp|btcostestimate|btendscan|btfloat48cmp|btfloat4cmp|" +
  751. "btfloat4sortsupport|btfloat84cmp|btfloat8cmp|btfloat8sortsupport|btgetbitmap|" +
  752. "btgettuple|btinsert|btint24cmp|btint28cmp|btint2cmp|btint2sortsupport|btint42cmp|" +
  753. "btint48cmp|btint4cmp|btint4sortsupport|btint82cmp|btint84cmp|btint8cmp|" +
  754. "btint8sortsupport|btmarkpos|btnamecmp|btnamesortsupport|btoidcmp|btoidsortsupport|" +
  755. "btoidvectorcmp|btoptions|btrecordcmp|btreltimecmp|btrescan|btrestrpos|btrim|" +
  756. "bttext_pattern_cmp|bttextcmp|bttidcmp|bttintervalcmp|btvacuumcleanup|" +
  757. "bytea_string_agg_finalfn|bytea_string_agg_transfn|byteacat|byteacmp|byteaeq|byteage|" +
  758. "byteagt|byteain|byteale|bytealike|bytealt|byteane|byteanlike|byteaout|bytearecv|byteasend|" +
  759. "cash_cmp|cash_div_cash|cash_div_flt4|cash_div_flt8|cash_div_int2|cash_div_int4|cash_eq|" +
  760. "cash_ge|cash_gt|cash_in|cash_le|cash_lt|cash_mi|cash_mul_flt4|cash_mul_flt8|" +
  761. "cash_mul_int2|cash_mul_int4|cash_ne|cash_out|cash_pl|cash_recv|cash_send|cash_words|" +
  762. "cashlarger|cashsmaller|cbrt|ceil|ceiling|center|char|char_length|character_length|chareq|" +
  763. "charge|chargt|charin|charle|charlt|charne|charout|charrecv|charsend|chr|cideq|cidin|cidout|" +
  764. "cidr|cidr_in|cidr_out|cidr_recv|cidr_send|cidrecv|cidsend|circle|circle_above|" +
  765. "circle_add_pt|circle_below|circle_center|circle_contain|circle_contain_pt|" +
  766. "circle_contained|circle_distance|circle_div_pt|circle_eq|circle_ge|circle_gt|circle_in|" +
  767. "circle_le|circle_left|circle_lt|circle_mul_pt|circle_ne|circle_out|circle_overabove|" +
  768. "circle_overbelow|circle_overlap|circle_overleft|circle_overright|circle_recv|" +
  769. "circle_right|circle_same|circle_send|circle_sub_pt|clock_timestamp|close_lb|close_ls|" +
  770. "close_lseg|close_pb|close_pl|close_ps|close_sb|close_sl|col_description|concat|concat_ws|" +
  771. "contjoinsel|contsel|convert|convert_from|convert_to|corr|cos|cot|count|covar_pop|" +
  772. "covar_samp|cstring_in|cstring_out|cstring_recv|cstring_send|cume_dist|current_database|" +
  773. "current_query|current_schema|current_schemas|current_setting|current_user|currtid|" +
  774. "currtid2|currval|cursor_to_xml|cursor_to_xmlschema|database_to_xml|" +
  775. "database_to_xml_and_xmlschema|database_to_xmlschema|date|date_cmp|date_cmp_timestamp|" +
  776. "date_cmp_timestamptz|date_eq|date_eq_timestamp|date_eq_timestamptz|date_ge|" +
  777. "date_ge_timestamp|date_ge_timestamptz|date_gt|date_gt_timestamp|date_gt_timestamptz|" +
  778. "date_in|date_larger|date_le|date_le_timestamp|date_le_timestamptz|date_lt|" +
  779. "date_lt_timestamp|date_lt_timestamptz|date_mi|date_mi_interval|date_mii|date_ne|" +
  780. "date_ne_timestamp|date_ne_timestamptz|date_out|date_part|date_pl_interval|date_pli|" +
  781. "date_recv|date_send|date_smaller|date_sortsupport|date_trunc|daterange|" +
  782. "daterange_canonical|daterange_subdiff|datetime_pl|datetimetz_pl|dcbrt|decode|degrees|" +
  783. "dense_rank|dexp|diagonal|diameter|dispell_init|dispell_lexize|dist_cpoly|dist_lb|dist_pb|" +
  784. "dist_pc|dist_pl|dist_ppath|dist_ps|dist_sb|dist_sl|div|dlog1|dlog10|domain_in|domain_recv|" +
  785. "dpow|dround|dsimple_init|dsimple_lexize|dsnowball_init|dsnowball_lexize|dsqrt|" +
  786. "dsynonym_init|dsynonym_lexize|dtrunc|elem_contained_by_range|encode|enum_cmp|enum_eq|" +
  787. "enum_first|enum_ge|enum_gt|enum_in|enum_larger|enum_last|enum_le|enum_lt|enum_ne|enum_out|" +
  788. "enum_range|enum_recv|enum_send|enum_smaller|eqjoinsel|eqsel|euc_cn_to_mic|" +
  789. "euc_cn_to_utf8|euc_jis_2004_to_shift_jis_2004|euc_jis_2004_to_utf8|euc_jp_to_mic|" +
  790. "euc_jp_to_sjis|euc_jp_to_utf8|euc_kr_to_mic|euc_kr_to_utf8|euc_tw_to_big5|" +
  791. "euc_tw_to_mic|euc_tw_to_utf8|event_trigger_in|event_trigger_out|every|exp|factorial|" +
  792. "family|fdw_handler_in|fdw_handler_out|first_value|float4|float48div|float48eq|float48ge|" +
  793. "float48gt|float48le|float48lt|float48mi|float48mul|float48ne|float48pl|float4_accum|" +
  794. "float4abs|float4div|float4eq|float4ge|float4gt|float4in|float4larger|float4le|float4lt|" +
  795. "float4mi|float4mul|float4ne|float4out|float4pl|float4recv|float4send|float4smaller|" +
  796. "float4um|float4up|float8|float84div|float84eq|float84ge|float84gt|float84le|float84lt|" +
  797. "float84mi|float84mul|float84ne|float84pl|float8_accum|float8_avg|float8_corr|" +
  798. "float8_covar_pop|float8_covar_samp|float8_regr_accum|float8_regr_avgx|" +
  799. "float8_regr_avgy|float8_regr_intercept|float8_regr_r2|float8_regr_slope|" +
  800. "float8_regr_sxx|float8_regr_sxy|float8_regr_syy|float8_stddev_pop|float8_stddev_samp|" +
  801. "float8_var_pop|float8_var_samp|float8abs|float8div|float8eq|float8ge|float8gt|float8in|" +
  802. "float8larger|float8le|float8lt|float8mi|float8mul|float8ne|float8out|float8pl|float8recv|" +
  803. "float8send|float8smaller|float8um|float8up|floor|flt4_mul_cash|flt8_mul_cash|" +
  804. "fmgr_c_validator|fmgr_internal_validator|fmgr_sql_validator|format|format_type|" +
  805. "gb18030_to_utf8|gbk_to_utf8|generate_series|generate_subscripts|get_bit|get_byte|" +
  806. "get_current_ts_config|getdatabaseencoding|getpgusername|gin_cmp_prefix|" +
  807. "gin_cmp_tslexeme|gin_extract_tsquery|gin_extract_tsvector|gin_tsquery_consistent|" +
  808. "ginarrayconsistent|ginarrayextract|ginbeginscan|ginbuild|ginbuildempty|ginbulkdelete|" +
  809. "gincostestimate|ginendscan|gingetbitmap|gininsert|ginmarkpos|ginoptions|" +
  810. "ginqueryarrayextract|ginrescan|ginrestrpos|ginvacuumcleanup|gist_box_compress|" +
  811. "gist_box_consistent|gist_box_decompress|gist_box_penalty|gist_box_picksplit|" +
  812. "gist_box_same|gist_box_union|gist_circle_compress|gist_circle_consistent|" +
  813. "gist_point_compress|gist_point_consistent|gist_point_distance|gist_poly_compress|" +
  814. "gist_poly_consistent|gistbeginscan|gistbuild|gistbuildempty|gistbulkdelete|" +
  815. "gistcostestimate|gistendscan|gistgetbitmap|gistgettuple|gistinsert|gistmarkpos|" +
  816. "gistoptions|gistrescan|gistrestrpos|gistvacuumcleanup|gtsquery_compress|" +
  817. "gtsquery_consistent|gtsquery_decompress|gtsquery_penalty|gtsquery_picksplit|" +
  818. "gtsquery_same|gtsquery_union|gtsvector_compress|gtsvector_consistent|" +
  819. "gtsvector_decompress|gtsvector_penalty|gtsvector_picksplit|gtsvector_same|" +
  820. "gtsvector_union|gtsvectorin|gtsvectorout|has_any_column_privilege|" +
  821. "has_column_privilege|has_database_privilege|has_foreign_data_wrapper_privilege|" +
  822. "has_function_privilege|has_language_privilege|has_schema_privilege|" +
  823. "has_sequence_privilege|has_server_privilege|has_table_privilege|" +
  824. "has_tablespace_privilege|has_type_privilege|hash_aclitem|hash_array|hash_numeric|" +
  825. "hash_range|hashbeginscan|hashbpchar|hashbuild|hashbuildempty|hashbulkdelete|hashchar|" +
  826. "hashcostestimate|hashendscan|hashenum|hashfloat4|hashfloat8|hashgetbitmap|hashgettuple|" +
  827. "hashinet|hashinsert|hashint2|hashint2vector|hashint4|hashint8|hashmacaddr|hashmarkpos|" +
  828. "hashname|hashoid|hashoidvector|hashoptions|hashrescan|hashrestrpos|hashtext|" +
  829. "hashvacuumcleanup|hashvarlena|height|host|hostmask|iclikejoinsel|iclikesel|" +
  830. "icnlikejoinsel|icnlikesel|icregexeqjoinsel|icregexeqsel|icregexnejoinsel|icregexnesel|" +
  831. "inet_client_addr|inet_client_port|inet_in|inet_out|inet_recv|inet_send|" +
  832. "inet_server_addr|inet_server_port|inetand|inetmi|inetmi_int8|inetnot|inetor|inetpl|" +
  833. "initcap|int2|int24div|int24eq|int24ge|int24gt|int24le|int24lt|int24mi|int24mul|int24ne|" +
  834. "int24pl|int28div|int28eq|int28ge|int28gt|int28le|int28lt|int28mi|int28mul|int28ne|int28pl|" +
  835. "int2_accum|int2_avg_accum|int2_mul_cash|int2_sum|int2abs|int2and|int2div|int2eq|int2ge|" +
  836. "int2gt|int2in|int2larger|int2le|int2lt|int2mi|int2mod|int2mul|int2ne|int2not|int2or|int2out|" +
  837. "int2pl|int2recv|int2send|int2shl|int2shr|int2smaller|int2um|int2up|int2vectoreq|" +
  838. "int2vectorin|int2vectorout|int2vectorrecv|int2vectorsend|int2xor|int4|int42div|int42eq|" +
  839. "int42ge|int42gt|int42le|int42lt|int42mi|int42mul|int42ne|int42pl|int48div|int48eq|int48ge|" +
  840. "int48gt|int48le|int48lt|int48mi|int48mul|int48ne|int48pl|int4_accum|int4_avg_accum|" +
  841. "int4_mul_cash|int4_sum|int4abs|int4and|int4div|int4eq|int4ge|int4gt|int4in|int4inc|" +
  842. "int4larger|int4le|int4lt|int4mi|int4mod|int4mul|int4ne|int4not|int4or|int4out|int4pl|" +
  843. "int4range|int4range_canonical|int4range_subdiff|int4recv|int4send|int4shl|int4shr|" +
  844. "int4smaller|int4um|int4up|int4xor|int8|int82div|int82eq|int82ge|int82gt|int82le|int82lt|" +
  845. "int82mi|int82mul|int82ne|int82pl|int84div|int84eq|int84ge|int84gt|int84le|int84lt|int84mi|" +
  846. "int84mul|int84ne|int84pl|int8_accum|int8_avg|int8_avg_accum|int8_sum|int8abs|int8and|" +
  847. "int8div|int8eq|int8ge|int8gt|int8in|int8inc|int8inc_any|int8inc_float8_float8|int8larger|" +
  848. "int8le|int8lt|int8mi|int8mod|int8mul|int8ne|int8not|int8or|int8out|int8pl|int8pl_inet|" +
  849. "int8range|int8range_canonical|int8range_subdiff|int8recv|int8send|int8shl|int8shr|" +
  850. "int8smaller|int8um|int8up|int8xor|integer_pl_date|inter_lb|inter_sb|inter_sl|internal_in|" +
  851. "internal_out|interval_accum|interval_avg|interval_cmp|interval_div|interval_eq|" +
  852. "interval_ge|interval_gt|interval_hash|interval_in|interval_larger|interval_le|" +
  853. "interval_lt|interval_mi|interval_mul|interval_ne|interval_out|interval_pl|" +
  854. "interval_pl_date|interval_pl_time|interval_pl_timestamp|interval_pl_timestamptz|" +
  855. "interval_pl_timetz|interval_recv|interval_send|interval_smaller|interval_transform|" +
  856. "interval_um|intervaltypmodin|intervaltypmodout|intinterval|isclosed|isempty|isfinite|" +
  857. "ishorizontal|iso8859_1_to_utf8|iso8859_to_utf8|iso_to_koi8r|iso_to_mic|iso_to_win1251|" +
  858. "iso_to_win866|isopen|isparallel|isperp|isvertical|johab_to_utf8|json_agg|" +
  859. "json_agg_finalfn|json_agg_transfn|json_array_element|json_array_element_text|" +
  860. "json_array_elements|json_array_length|json_each|json_each_text|json_extract_path|" +
  861. "json_extract_path_op|json_extract_path_text|json_extract_path_text_op|json_in|" +
  862. "json_object_field|json_object_field_text|json_object_keys|json_out|" +
  863. "json_populate_record|json_populate_recordset|json_recv|json_send|justify_days|" +
  864. "justify_hours|justify_interval|koi8r_to_iso|koi8r_to_mic|koi8r_to_utf8|" +
  865. "koi8r_to_win1251|koi8r_to_win866|koi8u_to_utf8|lag|language_handler_in|" +
  866. "language_handler_out|last_value|lastval|latin1_to_mic|latin2_to_mic|latin2_to_win1250|" +
  867. "latin3_to_mic|latin4_to_mic|lead|left|length|like|like_escape|likejoinsel|likesel|line|" +
  868. "line_distance|line_eq|line_horizontal|line_in|line_interpt|line_intersect|line_out|" +
  869. "line_parallel|line_perp|line_recv|line_send|line_vertical|ln|lo_close|lo_creat|lo_create|" +
  870. "lo_export|lo_import|lo_lseek|lo_lseek64|lo_open|lo_tell|lo_tell64|lo_truncate|" +
  871. "lo_truncate64|lo_unlink|log|loread|lower|lower_inc|lower_inf|lowrite|lpad|lseg|lseg_center|" +
  872. "lseg_distance|lseg_eq|lseg_ge|lseg_gt|lseg_horizontal|lseg_in|lseg_interpt|" +
  873. "lseg_intersect|lseg_le|lseg_length|lseg_lt|lseg_ne|lseg_out|lseg_parallel|lseg_perp|" +
  874. "lseg_recv|lseg_send|lseg_vertical|ltrim|macaddr_and|macaddr_cmp|macaddr_eq|macaddr_ge|" +
  875. "macaddr_gt|macaddr_in|macaddr_le|macaddr_lt|macaddr_ne|macaddr_not|macaddr_or|" +
  876. "macaddr_out|macaddr_recv|macaddr_send|makeaclitem|masklen|max|md5|mic_to_ascii|" +
  877. "mic_to_big5|mic_to_euc_cn|mic_to_euc_jp|mic_to_euc_kr|mic_to_euc_tw|mic_to_iso|" +
  878. "mic_to_koi8r|mic_to_latin1|mic_to_latin2|mic_to_latin3|mic_to_latin4|mic_to_sjis|" +
  879. "mic_to_win1250|mic_to_win1251|mic_to_win866|min|mktinterval|mod|money|mul_d_interval|" +
  880. "name|nameeq|namege|namegt|nameiclike|nameicnlike|nameicregexeq|nameicregexne|namein|" +
  881. "namele|namelike|namelt|namene|namenlike|nameout|namerecv|nameregexeq|nameregexne|namesend|" +
  882. "neqjoinsel|neqsel|netmask|network|network_cmp|network_eq|network_ge|network_gt|" +
  883. "network_le|network_lt|network_ne|network_sub|network_subeq|network_sup|network_supeq|" +
  884. "nextval|nlikejoinsel|nlikesel|notlike|now|npoints|nth_value|ntile|numeric_abs|" +
  885. "numeric_accum|numeric_add|numeric_avg|numeric_avg_accum|numeric_cmp|numeric_div|" +
  886. "numeric_div_trunc|numeric_eq|numeric_exp|numeric_fac|numeric_ge|numeric_gt|numeric_in|" +
  887. "numeric_inc|numeric_larger|numeric_le|numeric_ln|numeric_log|numeric_lt|numeric_mod|" +
  888. "numeric_mul|numeric_ne|numeric_out|numeric_power|numeric_recv|numeric_send|" +
  889. "numeric_smaller|numeric_sqrt|numeric_stddev_pop|numeric_stddev_samp|numeric_sub|" +
  890. "numeric_transform|numeric_uminus|numeric_uplus|numeric_var_pop|numeric_var_samp|" +
  891. "numerictypmodin|numerictypmodout|numnode|numrange|numrange_subdiff|obj_description|" +
  892. "octet_length|oid|oideq|oidge|oidgt|oidin|oidlarger|oidle|oidlt|oidne|oidout|oidrecv|oidsend|" +
  893. "oidsmaller|oidvectoreq|oidvectorge|oidvectorgt|oidvectorin|oidvectorle|oidvectorlt|" +
  894. "oidvectorne|oidvectorout|oidvectorrecv|oidvectorsend|oidvectortypes|on_pb|on_pl|" +
  895. "on_ppath|on_ps|on_sb|on_sl|opaque_in|opaque_out|overlaps|overlay|path|path_add|path_add_pt|" +
  896. "path_center|path_contain_pt|path_distance|path_div_pt|path_in|path_inter|path_length|" +
  897. "path_mul_pt|path_n_eq|path_n_ge|path_n_gt|path_n_le|path_n_lt|path_npoints|path_out|" +
  898. "path_recv|path_send|path_sub_pt|pclose|percent_rank|pg_advisory_lock|" +
  899. "pg_advisory_lock_shared|pg_advisory_unlock|pg_advisory_unlock_all|" +
  900. "pg_advisory_unlock_shared|pg_advisory_xact_lock|pg_advisory_xact_lock_shared|" +
  901. "pg_available_extension_versions|pg_available_extensions|pg_backend_pid|" +
  902. "pg_backup_start_time|pg_cancel_backend|pg_char_to_encoding|pg_client_encoding|" +
  903. "pg_collation_for|pg_collation_is_visible|pg_column_is_updatable|pg_column_size|" +
  904. "pg_conf_load_time|pg_conversion_is_visible|pg_create_restore_point|" +
  905. "pg_current_xlog_insert_location|pg_current_xlog_location|pg_cursor|pg_database_size|" +
  906. "pg_describe_object|pg_encoding_max_length|pg_encoding_to_char|" +
  907. "pg_event_trigger_dropped_objects|pg_export_snapshot|pg_extension_config_dump|" +
  908. "pg_extension_update_paths|pg_function_is_visible|pg_get_constraintdef|pg_get_expr|" +
  909. "pg_get_function_arguments|pg_get_function_identity_arguments|" +
  910. "pg_get_function_result|pg_get_functiondef|pg_get_indexdef|pg_get_keywords|" +
  911. "pg_get_multixact_members|pg_get_ruledef|pg_get_serial_sequence|pg_get_triggerdef|" +
  912. "pg_get_userbyid|pg_get_viewdef|pg_has_role|pg_identify_object|pg_indexes_size|" +
  913. "pg_is_in_backup|pg_is_in_recovery|pg_is_other_temp_schema|pg_is_xlog_replay_paused|" +
  914. "pg_last_xact_replay_timestamp|pg_last_xlog_receive_location|" +
  915. "pg_last_xlog_replay_location|pg_listening_channels|pg_lock_status|pg_ls_dir|" +
  916. "pg_my_temp_schema|pg_node_tree_in|pg_node_tree_out|pg_node_tree_recv|" +
  917. "pg_node_tree_send|pg_notify|pg_opclass_is_visible|pg_operator_is_visible|" +
  918. "pg_opfamily_is_visible|pg_options_to_table|pg_postmaster_start_time|" +
  919. "pg_prepared_statement|pg_prepared_xact|pg_read_binary_file|pg_read_file|" +
  920. "pg_relation_filenode|pg_relation_filepath|pg_relation_is_updatable|pg_relation_size|" +
  921. "pg_reload_conf|pg_rotate_logfile|pg_sequence_parameters|pg_show_all_settings|" +
  922. "pg_size_pretty|pg_sleep|pg_start_backup|pg_stat_clear_snapshot|pg_stat_file|" +
  923. "pg_stat_get_activity|pg_stat_get_analyze_count|pg_stat_get_autoanalyze_count|" +
  924. "pg_stat_get_autovacuum_count|pg_stat_get_backend_activity|" +
  925. "pg_stat_get_backend_activity_start|pg_stat_get_backend_client_addr|" +
  926. "pg_stat_get_backend_client_port|pg_stat_get_backend_dbid|pg_stat_get_backend_idset|" +
  927. "pg_stat_get_backend_pid|pg_stat_get_backend_start|pg_stat_get_backend_userid|" +
  928. "pg_stat_get_backend_waiting|pg_stat_get_backend_xact_start|" +
  929. "pg_stat_get_bgwriter_buf_written_checkpoints|" +
  930. "pg_stat_get_bgwriter_buf_written_clean|pg_stat_get_bgwriter_maxwritten_clean|" +
  931. "pg_stat_get_bgwriter_requested_checkpoints|pg_stat_get_bgwriter_stat_reset_time|" +
  932. "pg_stat_get_bgwriter_timed_checkpoints|pg_stat_get_blocks_fetched|" +
  933. "pg_stat_get_blocks_hit|pg_stat_get_buf_alloc|pg_stat_get_buf_fsync_backend|" +
  934. "pg_stat_get_buf_written_backend|pg_stat_get_checkpoint_sync_time|" +
  935. "pg_stat_get_checkpoint_write_time|pg_stat_get_db_blk_read_time|" +
  936. "pg_stat_get_db_blk_write_time|pg_stat_get_db_blocks_fetched|" +
  937. "pg_stat_get_db_blocks_hit|pg_stat_get_db_conflict_all|" +
  938. "pg_stat_get_db_conflict_bufferpin|pg_stat_get_db_conflict_lock|" +
  939. "pg_stat_get_db_conflict_snapshot|pg_stat_get_db_conflict_startup_deadlock|" +
  940. "pg_stat_get_db_conflict_tablespace|pg_stat_get_db_deadlocks|" +
  941. "pg_stat_get_db_numbackends|pg_stat_get_db_stat_reset_time|" +
  942. "pg_stat_get_db_temp_bytes|pg_stat_get_db_temp_files|pg_stat_get_db_tuples_deleted|" +
  943. "pg_stat_get_db_tuples_fetched|pg_stat_get_db_tuples_inserted|" +
  944. "pg_stat_get_db_tuples_returned|pg_stat_get_db_tuples_updated|" +
  945. "pg_stat_get_db_xact_commit|pg_stat_get_db_xact_rollback|pg_stat_get_dead_tuples|" +
  946. "pg_stat_get_function_calls|pg_stat_get_function_self_time|" +
  947. "pg_stat_get_function_total_time|pg_stat_get_last_analyze_time|" +
  948. "pg_stat_get_last_autoanalyze_time|pg_stat_get_last_autovacuum_time|" +
  949. "pg_stat_get_last_vacuum_time|pg_stat_get_live_tuples|pg_stat_get_numscans|" +
  950. "pg_stat_get_tuples_deleted|pg_stat_get_tuples_fetched|" +
  951. "pg_stat_get_tuples_hot_updated|pg_stat_get_tuples_inserted|" +
  952. "pg_stat_get_tuples_returned|pg_stat_get_tuples_updated|pg_stat_get_vacuum_count|" +
  953. "pg_stat_get_wal_senders|pg_stat_get_xact_blocks_fetched|" +
  954. "pg_stat_get_xact_blocks_hit|pg_stat_get_xact_function_calls|" +
  955. "pg_stat_get_xact_function_self_time|pg_stat_get_xact_function_total_time|" +
  956. "pg_stat_get_xact_numscans|pg_stat_get_xact_tuples_deleted|" +
  957. "pg_stat_get_xact_tuples_fetched|pg_stat_get_xact_tuples_hot_updated|" +
  958. "pg_stat_get_xact_tuples_inserted|pg_stat_get_xact_tuples_returned|" +
  959. "pg_stat_get_xact_tuples_updated|pg_stat_reset|pg_stat_reset_shared|" +
  960. "pg_stat_reset_single_function_counters|pg_stat_reset_single_table_counters|" +
  961. "pg_stop_backup|pg_switch_xlog|pg_table_is_visible|pg_table_size|" +
  962. "pg_tablespace_databases|pg_tablespace_location|pg_tablespace_size|" +
  963. "pg_terminate_backend|pg_timezone_abbrevs|pg_timezone_names|pg_total_relation_size|" +
  964. "pg_trigger_depth|pg_try_advisory_lock|pg_try_advisory_lock_shared|" +
  965. "pg_try_advisory_xact_lock|pg_try_advisory_xact_lock_shared|pg_ts_config_is_visible|" +
  966. "pg_ts_dict_is_visible|pg_ts_parser_is_visible|pg_ts_template_is_visible|" +
  967. "pg_type_is_visible|pg_typeof|pg_xlog_location_diff|pg_xlog_replay_pause|" +
  968. "pg_xlog_replay_resume|pg_xlogfile_name|pg_xlogfile_name_offset|pi|plainto_tsquery|" +
  969. "plpgsql_call_handler|plpgsql_inline_handler|plpgsql_validator|point|point_above|" +
  970. "point_add|point_below|point_distance|point_div|point_eq|point_horiz|point_in|point_left|" +
  971. "point_mul|point_ne|point_out|point_recv|point_right|point_send|point_sub|point_vert|" +
  972. "poly_above|poly_below|poly_center|poly_contain|poly_contain_pt|poly_contained|" +
  973. "poly_distance|poly_in|poly_left|poly_npoints|poly_out|poly_overabove|poly_overbelow|" +
  974. "poly_overlap|poly_overleft|poly_overright|poly_recv|poly_right|poly_same|poly_send|" +
  975. "polygon|popen|position|positionjoinsel|positionsel|postgresql_fdw_validator|pow|power|" +
  976. "prsd_end|prsd_headline|prsd_lextype|prsd_nexttoken|prsd_start|pt_contained_circle|" +
  977. "pt_contained_poly|query_to_xml|query_to_xml_and_xmlschema|query_to_xmlschema|" +
  978. "querytree|quote_ident|quote_literal|quote_nullable|radians|radius|random|range_adjacent|" +
  979. "range_after|range_before|range_cmp|range_contained_by|range_contains|" +
  980. "range_contains_elem|range_eq|range_ge|range_gist_compress|range_gist_consistent|" +
  981. "range_gist_decompress|range_gist_penalty|range_gist_picksplit|range_gist_same|" +
  982. "range_gist_union|range_gt|range_in|range_intersect|range_le|range_lt|range_minus|" +
  983. "range_ne|range_out|range_overlaps|range_overleft|range_overright|range_recv|range_send|" +
  984. "range_typanalyze|range_union|rangesel|rank|record_eq|record_ge|record_gt|record_in|" +
  985. "record_le|record_lt|record_ne|record_out|record_recv|record_send|regclass|regclassin|" +
  986. "regclassout|regclassrecv|regclasssend|regconfigin|regconfigout|regconfigrecv|" +
  987. "regconfigsend|regdictionaryin|regdictionaryout|regdictionaryrecv|regdictionarysend|" +
  988. "regexeqjoinsel|regexeqsel|regexnejoinsel|regexnesel|regexp_matches|regexp_replace|" +
  989. "regexp_split_to_array|regexp_split_to_table|regoperatorin|regoperatorout|" +
  990. "regoperatorrecv|regoperatorsend|regoperin|regoperout|regoperrecv|regopersend|" +
  991. "regprocedurein|regprocedureout|regprocedurerecv|regproceduresend|regprocin|regprocout|" +
  992. "regprocrecv|regprocsend|regr_avgx|regr_avgy|regr_count|regr_intercept|regr_r2|" +
  993. "regr_slope|regr_sxx|regr_sxy|regr_syy|regtypein|regtypeout|regtyperecv|regtypesend|" +
  994. "reltime|reltimeeq|reltimege|reltimegt|reltimein|reltimele|reltimelt|reltimene|reltimeout|" +
  995. "reltimerecv|reltimesend|repeat|replace|reverse|right|round|row_number|row_to_json|rpad|" +
  996. "rtrim|scalargtjoinsel|scalargtsel|scalarltjoinsel|scalarltsel|schema_to_xml|" +
  997. "schema_to_xml_and_xmlschema|schema_to_xmlschema|session_user|set_bit|set_byte|" +
  998. "set_config|set_masklen|setseed|setval|setweight|shell_in|shell_out|" +
  999. "shift_jis_2004_to_euc_jis_2004|shift_jis_2004_to_utf8|shobj_description|sign|" +
  1000. "similar_escape|sin|sjis_to_euc_jp|sjis_to_mic|sjis_to_utf8|slope|smgreq|smgrin|smgrne|" +
  1001. "smgrout|spg_kd_choose|spg_kd_config|spg_kd_inner_consistent|spg_kd_picksplit|" +
  1002. "spg_quad_choose|spg_quad_config|spg_quad_inner_consistent|spg_quad_leaf_consistent|" +
  1003. "spg_quad_picksplit|spg_range_quad_choose|spg_range_quad_config|" +
  1004. "spg_range_quad_inner_consistent|spg_range_quad_leaf_consistent|" +
  1005. "spg_range_quad_picksplit|spg_text_choose|spg_text_config|spg_text_inner_consistent|" +
  1006. "spg_text_leaf_consistent|spg_text_picksplit|spgbeginscan|spgbuild|spgbuildempty|" +
  1007. "spgbulkdelete|spgcanreturn|spgcostestimate|spgendscan|spggetbitmap|spggettuple|" +
  1008. "spginsert|spgmarkpos|spgoptions|spgrescan|spgrestrpos|spgvacuumcleanup|split_part|sqrt|" +
  1009. "statement_timestamp|stddev|stddev_pop|stddev_samp|string_agg|string_agg_finalfn|" +
  1010. "string_agg_transfn|string_to_array|strip|strpos|substr|substring|sum|" +
  1011. "suppress_redundant_updates_trigger|table_to_xml|table_to_xml_and_xmlschema|" +
  1012. "table_to_xmlschema|tan|text|text_ge|text_gt|text_larger|text_le|text_lt|text_pattern_ge|" +
  1013. "text_pattern_gt|text_pattern_le|text_pattern_lt|text_smaller|textanycat|textcat|texteq|" +
  1014. "texticlike|texticnlike|texticregexeq|texticregexne|textin|textlen|textlike|textne|" +
  1015. "textnlike|textout|textrecv|textregexeq|textregexne|textsend|thesaurus_init|" +
  1016. "thesaurus_lexize|tideq|tidge|tidgt|tidin|tidlarger|tidle|tidlt|tidne|tidout|tidrecv|tidsend|" +
  1017. "tidsmaller|time_cmp|time_eq|time_ge|time_gt|time_hash|time_in|time_larger|time_le|time_lt|" +
  1018. "time_mi_interval|time_mi_time|time_ne|time_out|time_pl_interval|time_recv|time_send|" +
  1019. "time_smaller|time_transform|timedate_pl|timemi|timenow|timeofday|timepl|timestamp_cmp|" +
  1020. "timestamp_cmp_date|timestamp_cmp_timestamptz|timestamp_eq|timestamp_eq_date|" +
  1021. "timestamp_eq_timestamptz|timestamp_ge|timestamp_ge_date|timestamp_ge_timestamptz|" +
  1022. "timestamp_gt|timestamp_gt_date|timestamp_gt_timestamptz|timestamp_hash|timestamp_in|" +
  1023. "timestamp_larger|timestamp_le|timestamp_le_date|timestamp_le_timestamptz|" +
  1024. "timestamp_lt|timestamp_lt_date|timestamp_lt_timestamptz|timestamp_mi|" +
  1025. "timestamp_mi_interval|timestamp_ne|timestamp_ne_date|timestamp_ne_timestamptz|" +
  1026. "timestamp_out|timestamp_pl_interval|timestamp_recv|timestamp_send|timestamp_smaller|" +
  1027. "timestamp_sortsupport|timestamp_transform|timestamptypmodin|timestamptypmodout|" +
  1028. "timestamptz_cmp|timestamptz_cmp_date|timestamptz_cmp_timestamp|timestamptz_eq|" +
  1029. "timestamptz_eq_date|timestamptz_eq_timestamp|timestamptz_ge|timestamptz_ge_date|" +
  1030. "timestamptz_ge_timestamp|timestamptz_gt|timestamptz_gt_date|" +
  1031. "timestamptz_gt_timestamp|timestamptz_in|timestamptz_larger|timestamptz_le|" +
  1032. "timestamptz_le_date|timestamptz_le_timestamp|timestamptz_lt|timestamptz_lt_date|" +
  1033. "timestamptz_lt_timestamp|timestamptz_mi|timestamptz_mi_interval|timestamptz_ne|" +
  1034. "timestamptz_ne_date|timestamptz_ne_timestamp|timestamptz_out|" +
  1035. "timestamptz_pl_interval|timestamptz_recv|timestamptz_send|timestamptz_smaller|" +
  1036. "timestamptztypmodin|timestamptztypmodout|timetypmodin|timetypmodout|timetz_cmp|" +
  1037. "timetz_eq|timetz_ge|timetz_gt|timetz_hash|timetz_in|timetz_larger|timetz_le|timetz_lt|" +
  1038. "timetz_mi_interval|timetz_ne|timetz_out|timetz_pl_interval|timetz_recv|timetz_send|" +
  1039. "timetz_smaller|timetzdate_pl|timetztypmodin|timetztypmodout|timezone|tinterval|" +
  1040. "tintervalct|tintervalend|tintervaleq|tintervalge|tintervalgt|tintervalin|tintervalle|" +
  1041. "tintervalleneq|tintervallenge|tintervallengt|tintervallenle|tintervallenlt|" +
  1042. "tintervallenne|tintervallt|tintervalne|tintervalout|tintervalov|tintervalrecv|" +
  1043. "tintervalrel|tintervalsame|tintervalsend|tintervalstart|to_ascii|to_char|to_date|to_hex|" +
  1044. "to_json|to_number|to_timestamp|to_tsquery|to_tsvector|transaction_timestamp|translate|" +
  1045. "trigger_in|trigger_out|trunc|ts_debug|ts_headline|ts_lexize|ts_match_qv|ts_match_tq|" +
  1046. "ts_match_tt|ts_match_vq|ts_parse|ts_rank|ts_rank_cd|ts_rewrite|ts_stat|ts_token_type|" +
  1047. "ts_typanalyze|tsmatchjoinsel|tsmatchsel|tsq_mcontained|tsq_mcontains|tsquery_and|" +
  1048. "tsquery_cmp|tsquery_eq|tsquery_ge|tsquery_gt|tsquery_le|tsquery_lt|tsquery_ne|" +
  1049. "tsquery_not|tsquery_or|tsqueryin|tsqueryout|tsqueryrecv|tsquerysend|tsrange|" +
  1050. "tsrange_subdiff|tstzrange|tstzrange_subdiff|tsvector_cmp|tsvector_concat|tsvector_eq|" +
  1051. "tsvector_ge|tsvector_gt|tsvector_le|tsvector_lt|tsvector_ne|tsvector_update_trigger|" +
  1052. "tsvector_update_trigger_column|tsvectorin|tsvectorout|tsvectorrecv|tsvectorsend|" +
  1053. "txid_current|txid_current_snapshot|txid_snapshot_in|txid_snapshot_out|" +
  1054. "txid_snapshot_recv|txid_snapshot_send|txid_snapshot_xip|txid_snapshot_xmax|" +
  1055. "txid_snapshot_xmin|txid_visible_in_snapshot|uhc_to_utf8|unique_key_recheck|unknownin|" +
  1056. "unknownout|unknownrecv|unknownsend|unnest|upper|upper_inc|upper_inf|utf8_to_ascii|" +
  1057. "utf8_to_big5|utf8_to_euc_cn|utf8_to_euc_jis_2004|utf8_to_euc_jp|utf8_to_euc_kr|" +
  1058. "utf8_to_euc_tw|utf8_to_gb18030|utf8_to_gbk|utf8_to_iso8859|utf8_to_iso8859_1|" +
  1059. "utf8_to_johab|utf8_to_koi8r|utf8_to_koi8u|utf8_to_shift_jis_2004|utf8_to_sjis|" +
  1060. "utf8_to_uhc|utf8_to_win|uuid_cmp|uuid_eq|uuid_ge|uuid_gt|uuid_hash|uuid_in|uuid_le|" +
  1061. "uuid_lt|uuid_ne|uuid_out|uuid_recv|uuid_send|var_pop|var_samp|varbit_in|varbit_out|" +
  1062. "varbit_recv|varbit_send|varbit_transform|varbitcmp|varbiteq|varbitge|varbitgt|varbitle|" +
  1063. "varbitlt|varbitne|varbittypmodin|varbittypmodout|varchar_transform|varcharin|" +
  1064. "varcharout|varcharrecv|varcharsend|varchartypmodin|varchartypmodout|variance|version|" +
  1065. "void_in|void_out|void_recv|void_send|width|width_bucket|win1250_to_latin2|" +
  1066. "win1250_to_mic|win1251_to_iso|win1251_to_koi8r|win1251_to_mic|win1251_to_win866|" +
  1067. "win866_to_iso|win866_to_koi8r|win866_to_mic|win866_to_win1251|win_to_utf8|xideq|" +
  1068. "xideqint4|xidin|xidout|xidrecv|xidsend|xml|xml_in|xml_is_well_formed|" +
  1069. "xml_is_well_formed_content|xml_is_well_formed_document|xml_out|xml_recv|xml_send|" +
  1070. "xmlagg|xmlcomment|xmlconcat2|xmlexists|xmlvalidate|xpath|xpath_exists"
  1071. );
  1072. var keywordMapper = this.createKeywordMapper({
  1073. "support.function": builtinFunctions,
  1074. "keyword": keywords
  1075. }, "identifier", true);
  1076. var sqlRules = [{
  1077. token : "string", // single line string -- assume dollar strings if multi-line for now
  1078. regex : "['](?:(?:\\\\.)|(?:[^'\\\\]))*?[']"
  1079. }, {
  1080. token : "variable.language", // pg identifier
  1081. regex : '".*?"'
  1082. }, {
  1083. token : "constant.numeric", // float
  1084. regex : "[+-]?\\d+(?:(?:\\.\\d*)?(?:[eE][+-]?\\d+)?)?\\b"
  1085. }, {
  1086. token : keywordMapper,
  1087. regex : "[a-zA-Z_][a-zA-Z0-9_$]*\\b" // TODO - Unicode in identifiers
  1088. }, {
  1089. token : "keyword.operator",
  1090. regex : "!|!!|!~|!~\\*|!~~|!~~\\*|#|##|#<|#<=|#<>|#=|#>|#>=|%|\\&|\\&\\&|\\&<|\\&<\\||\\&>|\\*|\\+|" +
  1091. "\\-|/|<|<#>|<\\->|<<|<<=|<<\\||<=|<>|<\\?>|<@|<\\^|=|>|>=|>>|>>=|>\\^|\\?#|\\?\\-|\\?\\-\\||" +
  1092. "\\?\\||\\?\\|\\||@|@\\-@|@>|@@|@@@|\\^|\\||\\|\\&>|\\|/|\\|>>|\\|\\||\\|\\|/|~|~\\*|~<=~|~<~|" +
  1093. "~=|~>=~|~>~|~~|~~\\*"
  1094. }, {
  1095. token : "paren.lparen",
  1096. regex : "[\\(]"
  1097. }, {
  1098. token : "paren.rparen",
  1099. regex : "[\\)]"
  1100. }, {
  1101. token : "text",
  1102. regex : "\\s+"
  1103. }
  1104. ];
  1105. this.$rules = {
  1106. "start" : [{
  1107. token : "comment",
  1108. regex : "--.*$"
  1109. },
  1110. DocCommentHighlightRules.getStartRule("doc-start"),
  1111. {
  1112. token : "comment", // multi-line comment
  1113. regex : "\\/\\*",
  1114. next : "comment"
  1115. },{
  1116. token : "keyword.statementBegin",
  1117. regex : "^[a-zA-Z]+", // Could enumerate starting keywords but this allows things to work when new statements are added.
  1118. next : "statement"
  1119. },{
  1120. token : "support.buildin", // psql directive
  1121. regex : "^\\\\[\\S]+.*$"
  1122. }
  1123. ],
  1124. "statement" : [{
  1125. token : "comment",
  1126. regex : "--.*$"
  1127. }, {
  1128. token : "comment", // multi-line comment
  1129. regex : "\\/\\*",
  1130. next : "commentStatement"
  1131. }, {
  1132. token : "statementEnd",
  1133. regex : ";",
  1134. next : "start"
  1135. }, {
  1136. token : "string",
  1137. regex : "\\$perl\\$",
  1138. next : "perl-start"
  1139. }, {
  1140. token : "string",
  1141. regex : "\\$python\\$",
  1142. next : "python-start"
  1143. }, {
  1144. token : "string",
  1145. regex : "\\$json\\$",
  1146. next : "json-start"
  1147. }, {
  1148. token : "string",
  1149. regex : "\\$(js|javascript)\\$",
  1150. next : "javascript-start"
  1151. }, {
  1152. token : "string",
  1153. regex : "\\$[\\w_0-9]*\\$$", // dollar quote at the end of a line
  1154. next : "dollarSql"
  1155. }, {
  1156. token : "string",
  1157. regex : "\\$[\\w_0-9]*\\$",
  1158. next : "dollarStatementString"
  1159. }
  1160. ].concat(sqlRules),
  1161. "dollarSql" : [{
  1162. token : "comment",
  1163. regex : "--.*$"
  1164. }, {
  1165. token : "comment", // multi-line comment
  1166. regex : "\\/\\*",
  1167. next : "commentDollarSql"
  1168. }, {
  1169. token : "string", // end quoting with dollar at the start of a line
  1170. regex : "^\\$[\\w_0-9]*\\$",
  1171. next : "statement"
  1172. }, {
  1173. token : "string",
  1174. regex : "\\$[\\w_0-9]*\\$",
  1175. next : "dollarSqlString"
  1176. }
  1177. ].concat(sqlRules),
  1178. "comment" : [{
  1179. token : "comment", // closing comment
  1180. regex : ".*?\\*\\/",
  1181. next : "start"
  1182. }, {
  1183. token : "comment", // comment spanning whole line
  1184. regex : ".+"
  1185. }
  1186. ],
  1187. "commentStatement" : [{
  1188. token : "comment", // closing comment
  1189. regex : ".*?\\*\\/",
  1190. next : "statement"
  1191. }, {
  1192. token : "comment", // comment spanning whole line
  1193. regex : ".+"
  1194. }
  1195. ],
  1196. "commentDollarSql" : [{
  1197. token : "comment", // closing comment
  1198. regex : ".*?\\*\\/",
  1199. next : "dollarSql"
  1200. }, {
  1201. token : "comment", // comment spanning whole line
  1202. regex : ".+"
  1203. }
  1204. ],
  1205. "dollarStatementString" : [{
  1206. token : "string", // closing dollarstring
  1207. regex : ".*?\\$[\\w_0-9]*\\$",
  1208. next : "statement"
  1209. }, {
  1210. token : "string", // dollarstring spanning whole line
  1211. regex : ".+"
  1212. }
  1213. ],
  1214. "dollarSqlString" : [{
  1215. token : "string", // closing dollarstring
  1216. regex : ".*?\\$[\\w_0-9]*\\$",
  1217. next : "dollarSql"
  1218. }, {
  1219. token : "string", // dollarstring spanning whole line
  1220. regex : ".+"
  1221. }
  1222. ]
  1223. };
  1224. this.embedRules(DocCommentHighlightRules, "doc-", [ DocCommentHighlightRules.getEndRule("start") ]);
  1225. this.embedRules(PerlHighlightRules, "perl-", [{token : "string", regex : "\\$perl\\$", next : "statement"}]);
  1226. this.embedRules(PythonHighlightRules, "python-", [{token : "string", regex : "\\$python\\$", next : "statement"}]);
  1227. this.embedRules(JsonHighlightRules, "json-", [{token : "string", regex : "\\$json\\$", next : "statement"}]);
  1228. this.embedRules(JavaScriptHighlightRules, "javascript-", [{token : "string", regex : "\\$(js|javascript)\\$", next : "statement"}]);
  1229. };
  1230. oop.inherits(PgsqlHighlightRules, TextHighlightRules);
  1231. exports.PgsqlHighlightRules = PgsqlHighlightRules;
  1232. });
  1233. ace.define("ace/mode/pgsql",["require","exports","module","ace/lib/oop","ace/mode/text","ace/mode/pgsql_highlight_rules","ace/range"], function(require, exports, module) {
  1234. var oop = require("../lib/oop");
  1235. var TextMode = require("../mode/text").Mode;
  1236. var PgsqlHighlightRules = require("./pgsql_highlight_rules").PgsqlHighlightRules;
  1237. var Range = require("../range").Range;
  1238. var Mode = function() {
  1239. this.HighlightRules = PgsqlHighlightRules;
  1240. };
  1241. oop.inherits(Mode, TextMode);
  1242. (function() {
  1243. this.lineCommentStart = "--";
  1244. this.blockComment = {start: "/*", end: "*/"};
  1245. this.getNextLineIndent = function(state, line, tab) {
  1246. if (state == "start" || state == "keyword.statementEnd") {
  1247. return "";
  1248. } else {
  1249. return this.$getIndent(line); // Keep whatever indent the previous line has
  1250. }
  1251. }
  1252. this.$id = "ace/mode/pgsql";
  1253. }).call(Mode.prototype);
  1254. exports.Mode = Mode;
  1255. });