pgsql_highlight_rules.js 44 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619
  1. /* ***** BEGIN LICENSE BLOCK *****
  2. * Distributed under the BSD license:
  3. *
  4. * Copyright (c) 2010, Ajax.org B.V.
  5. * All rights reserved.
  6. *
  7. * Redistribution and use in source and binary forms, with or without
  8. * modification, are permitted provided that the following conditions are met:
  9. * * Redistributions of source code must retain the above copyright
  10. * notice, this list of conditions and the following disclaimer.
  11. * * Redistributions in binary form must reproduce the above copyright
  12. * notice, this list of conditions and the following disclaimer in the
  13. * documentation and/or other materials provided with the distribution.
  14. * * Neither the name of Ajax.org B.V. nor the
  15. * names of its contributors may be used to endorse or promote products
  16. * derived from this software without specific prior written permission.
  17. *
  18. * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
  19. * ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
  20. * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
  21. * DISCLAIMED. IN NO EVENT SHALL AJAX.ORG B.V. BE LIABLE FOR ANY
  22. * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
  23. * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
  24. * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
  25. * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
  26. * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
  27. * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
  28. *
  29. * ***** END LICENSE BLOCK ***** */
  30. define(function(require, exports, module) {
  31. var oop = require("../lib/oop");
  32. var lang = require("../lib/lang");
  33. var DocCommentHighlightRules = require("./doc_comment_highlight_rules").DocCommentHighlightRules;
  34. var TextHighlightRules = require("./text_highlight_rules").TextHighlightRules;
  35. // Syntax highlighting for pl/languages and json.
  36. var PerlHighlightRules = require("./perl_highlight_rules").PerlHighlightRules;
  37. var PythonHighlightRules = require("./python_highlight_rules").PythonHighlightRules;
  38. var JsonHighlightRules = require("./json_highlight_rules").JsonHighlightRules;
  39. var JavaScriptHighlightRules = require("./javascript_highlight_rules").JavaScriptHighlightRules;
  40. var PgsqlHighlightRules = function() {
  41. // Keywords, functions, operators last updated for pg 9.3.
  42. var keywords = (
  43. "abort|absolute|abstime|access|aclitem|action|add|admin|after|aggregate|all|also|alter|always|" +
  44. "analyse|analyze|and|any|anyarray|anyelement|anyenum|anynonarray|anyrange|array|as|asc|" +
  45. "assertion|assignment|asymmetric|at|attribute|authorization|backward|before|begin|between|" +
  46. "bigint|binary|bit|bool|boolean|both|box|bpchar|by|bytea|cache|called|cascade|cascaded|case|cast|" +
  47. "catalog|chain|char|character|characteristics|check|checkpoint|cid|cidr|circle|class|close|" +
  48. "cluster|coalesce|collate|collation|column|comment|comments|commit|committed|concurrently|" +
  49. "configuration|connection|constraint|constraints|content|continue|conversion|copy|cost|" +
  50. "create|cross|cstring|csv|current|current_catalog|current_date|current_role|" +
  51. "current_schema|current_time|current_timestamp|current_user|cursor|cycle|data|database|" +
  52. "date|daterange|day|deallocate|dec|decimal|declare|default|defaults|deferrable|deferred|" +
  53. "definer|delete|delimiter|delimiters|desc|dictionary|disable|discard|distinct|do|document|" +
  54. "domain|double|drop|each|else|enable|encoding|encrypted|end|enum|escape|event|event_trigger|" +
  55. "except|exclude|excluding|exclusive|execute|exists|explain|extension|external|extract|false|" +
  56. "family|fdw_handler|fetch|first|float|float4|float8|following|for|force|foreign|forward|" +
  57. "freeze|from|full|function|functions|global|grant|granted|greatest|group|gtsvector|handler|" +
  58. "having|header|hold|hour|identity|if|ilike|immediate|immutable|implicit|in|including|" +
  59. "increment|index|indexes|inet|inherit|inherits|initially|inline|inner|inout|input|" +
  60. "insensitive|insert|instead|int|int2|int2vector|int4|int4range|int8|int8range|integer|" +
  61. "internal|intersect|interval|into|invoker|is|isnull|isolation|join|json|key|label|language|" +
  62. "language_handler|large|last|lateral|lc_collate|lc_ctype|leading|leakproof|least|left|level|" +
  63. "like|limit|line|listen|load|local|localtime|localtimestamp|location|lock|lseg|macaddr|" +
  64. "mapping|match|materialized|maxvalue|minute|minvalue|mode|money|month|move|name|names|" +
  65. "national|natural|nchar|next|no|none|not|nothing|notify|notnull|nowait|null|nullif|nulls|" +
  66. "numeric|numrange|object|of|off|offset|oid|oids|oidvector|on|only|opaque|operator|option|" +
  67. "options|or|order|out|outer|over|overlaps|overlay|owned|owner|parser|partial|partition|passing|" +
  68. "password|path|pg_attribute|pg_auth_members|pg_authid|pg_class|pg_database|pg_node_tree|" +
  69. "pg_proc|pg_type|placing|plans|point|polygon|position|preceding|precision|prepare|prepared|" +
  70. "preserve|primary|prior|privileges|procedural|procedure|program|quote|range|read|real|" +
  71. "reassign|recheck|record|recursive|ref|refcursor|references|refresh|regclass|regconfig|" +
  72. "regdictionary|regoper|regoperator|regproc|regprocedure|regtype|reindex|relative|release|" +
  73. "reltime|rename|repeatable|replace|replica|reset|restart|restrict|returning|returns|revoke|" +
  74. "right|role|rollback|row|rows|rule|savepoint|schema|scroll|search|second|security|select|" +
  75. "sequence|sequences|serializable|server|session|session_user|set|setof|share|show|similar|" +
  76. "simple|smallint|smgr|snapshot|some|stable|standalone|start|statement|statistics|stdin|" +
  77. "stdout|storage|strict|strip|substring|symmetric|sysid|system|table|tables|tablespace|temp|" +
  78. "template|temporary|text|then|tid|time|timestamp|timestamptz|timetz|tinterval|to|trailing|" +
  79. "transaction|treat|trigger|trim|true|truncate|trusted|tsquery|tsrange|tstzrange|tsvector|" +
  80. "txid_snapshot|type|types|unbounded|uncommitted|unencrypted|union|unique|unknown|unlisten|" +
  81. "unlogged|until|update|user|using|uuid|vacuum|valid|validate|validator|value|values|varbit|" +
  82. "varchar|variadic|varying|verbose|version|view|void|volatile|when|where|whitespace|window|" +
  83. "with|without|work|wrapper|write|xid|xml|xmlattributes|xmlconcat|xmlelement|xmlexists|" +
  84. "xmlforest|xmlparse|xmlpi|xmlroot|xmlserialize|year|yes|zone"
  85. );
  86. var builtinFunctions = (
  87. "RI_FKey_cascade_del|RI_FKey_cascade_upd|RI_FKey_check_ins|RI_FKey_check_upd|" +
  88. "RI_FKey_noaction_del|RI_FKey_noaction_upd|RI_FKey_restrict_del|RI_FKey_restrict_upd|" +
  89. "RI_FKey_setdefault_del|RI_FKey_setdefault_upd|RI_FKey_setnull_del|" +
  90. "RI_FKey_setnull_upd|abbrev|abs|abstime|abstimeeq|abstimege|abstimegt|abstimein|abstimele|" +
  91. "abstimelt|abstimene|abstimeout|abstimerecv|abstimesend|aclcontains|acldefault|" +
  92. "aclexplode|aclinsert|aclitemeq|aclitemin|aclitemout|aclremove|acos|age|any_in|any_out|" +
  93. "anyarray_in|anyarray_out|anyarray_recv|anyarray_send|anyelement_in|anyelement_out|" +
  94. "anyenum_in|anyenum_out|anynonarray_in|anynonarray_out|anyrange_in|anyrange_out|" +
  95. "anytextcat|area|areajoinsel|areasel|array_agg|array_agg_finalfn|array_agg_transfn|" +
  96. "array_append|array_cat|array_dims|array_eq|array_fill|array_ge|array_gt|array_in|" +
  97. "array_larger|array_le|array_length|array_lower|array_lt|array_ndims|array_ne|array_out|" +
  98. "array_prepend|array_recv|array_remove|array_replace|array_send|array_smaller|" +
  99. "array_to_json|array_to_string|array_typanalyze|array_upper|arraycontained|" +
  100. "arraycontains|arraycontjoinsel|arraycontsel|arrayoverlap|ascii|ascii_to_mic|" +
  101. "ascii_to_utf8|asin|atan|atan2|avg|big5_to_euc_tw|big5_to_mic|big5_to_utf8|bit_and|bit_in|" +
  102. "bit_length|bit_or|bit_out|bit_recv|bit_send|bitand|bitcat|bitcmp|biteq|bitge|bitgt|bitle|" +
  103. "bitlt|bitne|bitnot|bitor|bitshiftleft|bitshiftright|bittypmodin|bittypmodout|bitxor|bool|" +
  104. "bool_and|bool_or|booland_statefunc|booleq|boolge|boolgt|boolin|boolle|boollt|boolne|" +
  105. "boolor_statefunc|boolout|boolrecv|boolsend|box|box_above|box_above_eq|box_add|box_below|" +
  106. "box_below_eq|box_center|box_contain|box_contain_pt|box_contained|box_distance|box_div|" +
  107. "box_eq|box_ge|box_gt|box_in|box_intersect|box_le|box_left|box_lt|box_mul|box_out|" +
  108. "box_overabove|box_overbelow|box_overlap|box_overleft|box_overright|box_recv|box_right|" +
  109. "box_same|box_send|box_sub|bpchar_larger|bpchar_pattern_ge|bpchar_pattern_gt|" +
  110. "bpchar_pattern_le|bpchar_pattern_lt|bpchar_smaller|bpcharcmp|bpchareq|bpcharge|" +
  111. "bpchargt|bpchariclike|bpcharicnlike|bpcharicregexeq|bpcharicregexne|bpcharin|bpcharle|" +
  112. "bpcharlike|bpcharlt|bpcharne|bpcharnlike|bpcharout|bpcharrecv|bpcharregexeq|" +
  113. "bpcharregexne|bpcharsend|bpchartypmodin|bpchartypmodout|broadcast|btabstimecmp|" +
  114. "btarraycmp|btbeginscan|btboolcmp|btbpchar_pattern_cmp|btbuild|btbuildempty|" +
  115. "btbulkdelete|btcanreturn|btcharcmp|btcostestimate|btendscan|btfloat48cmp|btfloat4cmp|" +
  116. "btfloat4sortsupport|btfloat84cmp|btfloat8cmp|btfloat8sortsupport|btgetbitmap|" +
  117. "btgettuple|btinsert|btint24cmp|btint28cmp|btint2cmp|btint2sortsupport|btint42cmp|" +
  118. "btint48cmp|btint4cmp|btint4sortsupport|btint82cmp|btint84cmp|btint8cmp|" +
  119. "btint8sortsupport|btmarkpos|btnamecmp|btnamesortsupport|btoidcmp|btoidsortsupport|" +
  120. "btoidvectorcmp|btoptions|btrecordcmp|btreltimecmp|btrescan|btrestrpos|btrim|" +
  121. "bttext_pattern_cmp|bttextcmp|bttidcmp|bttintervalcmp|btvacuumcleanup|" +
  122. "bytea_string_agg_finalfn|bytea_string_agg_transfn|byteacat|byteacmp|byteaeq|byteage|" +
  123. "byteagt|byteain|byteale|bytealike|bytealt|byteane|byteanlike|byteaout|bytearecv|byteasend|" +
  124. "cash_cmp|cash_div_cash|cash_div_flt4|cash_div_flt8|cash_div_int2|cash_div_int4|cash_eq|" +
  125. "cash_ge|cash_gt|cash_in|cash_le|cash_lt|cash_mi|cash_mul_flt4|cash_mul_flt8|" +
  126. "cash_mul_int2|cash_mul_int4|cash_ne|cash_out|cash_pl|cash_recv|cash_send|cash_words|" +
  127. "cashlarger|cashsmaller|cbrt|ceil|ceiling|center|char|char_length|character_length|chareq|" +
  128. "charge|chargt|charin|charle|charlt|charne|charout|charrecv|charsend|chr|cideq|cidin|cidout|" +
  129. "cidr|cidr_in|cidr_out|cidr_recv|cidr_send|cidrecv|cidsend|circle|circle_above|" +
  130. "circle_add_pt|circle_below|circle_center|circle_contain|circle_contain_pt|" +
  131. "circle_contained|circle_distance|circle_div_pt|circle_eq|circle_ge|circle_gt|circle_in|" +
  132. "circle_le|circle_left|circle_lt|circle_mul_pt|circle_ne|circle_out|circle_overabove|" +
  133. "circle_overbelow|circle_overlap|circle_overleft|circle_overright|circle_recv|" +
  134. "circle_right|circle_same|circle_send|circle_sub_pt|clock_timestamp|close_lb|close_ls|" +
  135. "close_lseg|close_pb|close_pl|close_ps|close_sb|close_sl|col_description|concat|concat_ws|" +
  136. "contjoinsel|contsel|convert|convert_from|convert_to|corr|cos|cot|count|covar_pop|" +
  137. "covar_samp|cstring_in|cstring_out|cstring_recv|cstring_send|cume_dist|current_database|" +
  138. "current_query|current_schema|current_schemas|current_setting|current_user|currtid|" +
  139. "currtid2|currval|cursor_to_xml|cursor_to_xmlschema|database_to_xml|" +
  140. "database_to_xml_and_xmlschema|database_to_xmlschema|date|date_cmp|date_cmp_timestamp|" +
  141. "date_cmp_timestamptz|date_eq|date_eq_timestamp|date_eq_timestamptz|date_ge|" +
  142. "date_ge_timestamp|date_ge_timestamptz|date_gt|date_gt_timestamp|date_gt_timestamptz|" +
  143. "date_in|date_larger|date_le|date_le_timestamp|date_le_timestamptz|date_lt|" +
  144. "date_lt_timestamp|date_lt_timestamptz|date_mi|date_mi_interval|date_mii|date_ne|" +
  145. "date_ne_timestamp|date_ne_timestamptz|date_out|date_part|date_pl_interval|date_pli|" +
  146. "date_recv|date_send|date_smaller|date_sortsupport|date_trunc|daterange|" +
  147. "daterange_canonical|daterange_subdiff|datetime_pl|datetimetz_pl|dcbrt|decode|degrees|" +
  148. "dense_rank|dexp|diagonal|diameter|dispell_init|dispell_lexize|dist_cpoly|dist_lb|dist_pb|" +
  149. "dist_pc|dist_pl|dist_ppath|dist_ps|dist_sb|dist_sl|div|dlog1|dlog10|domain_in|domain_recv|" +
  150. "dpow|dround|dsimple_init|dsimple_lexize|dsnowball_init|dsnowball_lexize|dsqrt|" +
  151. "dsynonym_init|dsynonym_lexize|dtrunc|elem_contained_by_range|encode|enum_cmp|enum_eq|" +
  152. "enum_first|enum_ge|enum_gt|enum_in|enum_larger|enum_last|enum_le|enum_lt|enum_ne|enum_out|" +
  153. "enum_range|enum_recv|enum_send|enum_smaller|eqjoinsel|eqsel|euc_cn_to_mic|" +
  154. "euc_cn_to_utf8|euc_jis_2004_to_shift_jis_2004|euc_jis_2004_to_utf8|euc_jp_to_mic|" +
  155. "euc_jp_to_sjis|euc_jp_to_utf8|euc_kr_to_mic|euc_kr_to_utf8|euc_tw_to_big5|" +
  156. "euc_tw_to_mic|euc_tw_to_utf8|event_trigger_in|event_trigger_out|every|exp|factorial|" +
  157. "family|fdw_handler_in|fdw_handler_out|first_value|float4|float48div|float48eq|float48ge|" +
  158. "float48gt|float48le|float48lt|float48mi|float48mul|float48ne|float48pl|float4_accum|" +
  159. "float4abs|float4div|float4eq|float4ge|float4gt|float4in|float4larger|float4le|float4lt|" +
  160. "float4mi|float4mul|float4ne|float4out|float4pl|float4recv|float4send|float4smaller|" +
  161. "float4um|float4up|float8|float84div|float84eq|float84ge|float84gt|float84le|float84lt|" +
  162. "float84mi|float84mul|float84ne|float84pl|float8_accum|float8_avg|float8_corr|" +
  163. "float8_covar_pop|float8_covar_samp|float8_regr_accum|float8_regr_avgx|" +
  164. "float8_regr_avgy|float8_regr_intercept|float8_regr_r2|float8_regr_slope|" +
  165. "float8_regr_sxx|float8_regr_sxy|float8_regr_syy|float8_stddev_pop|float8_stddev_samp|" +
  166. "float8_var_pop|float8_var_samp|float8abs|float8div|float8eq|float8ge|float8gt|float8in|" +
  167. "float8larger|float8le|float8lt|float8mi|float8mul|float8ne|float8out|float8pl|float8recv|" +
  168. "float8send|float8smaller|float8um|float8up|floor|flt4_mul_cash|flt8_mul_cash|" +
  169. "fmgr_c_validator|fmgr_internal_validator|fmgr_sql_validator|format|format_type|" +
  170. "gb18030_to_utf8|gbk_to_utf8|generate_series|generate_subscripts|get_bit|get_byte|" +
  171. "get_current_ts_config|getdatabaseencoding|getpgusername|gin_cmp_prefix|" +
  172. "gin_cmp_tslexeme|gin_extract_tsquery|gin_extract_tsvector|gin_tsquery_consistent|" +
  173. "ginarrayconsistent|ginarrayextract|ginbeginscan|ginbuild|ginbuildempty|ginbulkdelete|" +
  174. "gincostestimate|ginendscan|gingetbitmap|gininsert|ginmarkpos|ginoptions|" +
  175. "ginqueryarrayextract|ginrescan|ginrestrpos|ginvacuumcleanup|gist_box_compress|" +
  176. "gist_box_consistent|gist_box_decompress|gist_box_penalty|gist_box_picksplit|" +
  177. "gist_box_same|gist_box_union|gist_circle_compress|gist_circle_consistent|" +
  178. "gist_point_compress|gist_point_consistent|gist_point_distance|gist_poly_compress|" +
  179. "gist_poly_consistent|gistbeginscan|gistbuild|gistbuildempty|gistbulkdelete|" +
  180. "gistcostestimate|gistendscan|gistgetbitmap|gistgettuple|gistinsert|gistmarkpos|" +
  181. "gistoptions|gistrescan|gistrestrpos|gistvacuumcleanup|gtsquery_compress|" +
  182. "gtsquery_consistent|gtsquery_decompress|gtsquery_penalty|gtsquery_picksplit|" +
  183. "gtsquery_same|gtsquery_union|gtsvector_compress|gtsvector_consistent|" +
  184. "gtsvector_decompress|gtsvector_penalty|gtsvector_picksplit|gtsvector_same|" +
  185. "gtsvector_union|gtsvectorin|gtsvectorout|has_any_column_privilege|" +
  186. "has_column_privilege|has_database_privilege|has_foreign_data_wrapper_privilege|" +
  187. "has_function_privilege|has_language_privilege|has_schema_privilege|" +
  188. "has_sequence_privilege|has_server_privilege|has_table_privilege|" +
  189. "has_tablespace_privilege|has_type_privilege|hash_aclitem|hash_array|hash_numeric|" +
  190. "hash_range|hashbeginscan|hashbpchar|hashbuild|hashbuildempty|hashbulkdelete|hashchar|" +
  191. "hashcostestimate|hashendscan|hashenum|hashfloat4|hashfloat8|hashgetbitmap|hashgettuple|" +
  192. "hashinet|hashinsert|hashint2|hashint2vector|hashint4|hashint8|hashmacaddr|hashmarkpos|" +
  193. "hashname|hashoid|hashoidvector|hashoptions|hashrescan|hashrestrpos|hashtext|" +
  194. "hashvacuumcleanup|hashvarlena|height|host|hostmask|iclikejoinsel|iclikesel|" +
  195. "icnlikejoinsel|icnlikesel|icregexeqjoinsel|icregexeqsel|icregexnejoinsel|icregexnesel|" +
  196. "inet_client_addr|inet_client_port|inet_in|inet_out|inet_recv|inet_send|" +
  197. "inet_server_addr|inet_server_port|inetand|inetmi|inetmi_int8|inetnot|inetor|inetpl|" +
  198. "initcap|int2|int24div|int24eq|int24ge|int24gt|int24le|int24lt|int24mi|int24mul|int24ne|" +
  199. "int24pl|int28div|int28eq|int28ge|int28gt|int28le|int28lt|int28mi|int28mul|int28ne|int28pl|" +
  200. "int2_accum|int2_avg_accum|int2_mul_cash|int2_sum|int2abs|int2and|int2div|int2eq|int2ge|" +
  201. "int2gt|int2in|int2larger|int2le|int2lt|int2mi|int2mod|int2mul|int2ne|int2not|int2or|int2out|" +
  202. "int2pl|int2recv|int2send|int2shl|int2shr|int2smaller|int2um|int2up|int2vectoreq|" +
  203. "int2vectorin|int2vectorout|int2vectorrecv|int2vectorsend|int2xor|int4|int42div|int42eq|" +
  204. "int42ge|int42gt|int42le|int42lt|int42mi|int42mul|int42ne|int42pl|int48div|int48eq|int48ge|" +
  205. "int48gt|int48le|int48lt|int48mi|int48mul|int48ne|int48pl|int4_accum|int4_avg_accum|" +
  206. "int4_mul_cash|int4_sum|int4abs|int4and|int4div|int4eq|int4ge|int4gt|int4in|int4inc|" +
  207. "int4larger|int4le|int4lt|int4mi|int4mod|int4mul|int4ne|int4not|int4or|int4out|int4pl|" +
  208. "int4range|int4range_canonical|int4range_subdiff|int4recv|int4send|int4shl|int4shr|" +
  209. "int4smaller|int4um|int4up|int4xor|int8|int82div|int82eq|int82ge|int82gt|int82le|int82lt|" +
  210. "int82mi|int82mul|int82ne|int82pl|int84div|int84eq|int84ge|int84gt|int84le|int84lt|int84mi|" +
  211. "int84mul|int84ne|int84pl|int8_accum|int8_avg|int8_avg_accum|int8_sum|int8abs|int8and|" +
  212. "int8div|int8eq|int8ge|int8gt|int8in|int8inc|int8inc_any|int8inc_float8_float8|int8larger|" +
  213. "int8le|int8lt|int8mi|int8mod|int8mul|int8ne|int8not|int8or|int8out|int8pl|int8pl_inet|" +
  214. "int8range|int8range_canonical|int8range_subdiff|int8recv|int8send|int8shl|int8shr|" +
  215. "int8smaller|int8um|int8up|int8xor|integer_pl_date|inter_lb|inter_sb|inter_sl|internal_in|" +
  216. "internal_out|interval_accum|interval_avg|interval_cmp|interval_div|interval_eq|" +
  217. "interval_ge|interval_gt|interval_hash|interval_in|interval_larger|interval_le|" +
  218. "interval_lt|interval_mi|interval_mul|interval_ne|interval_out|interval_pl|" +
  219. "interval_pl_date|interval_pl_time|interval_pl_timestamp|interval_pl_timestamptz|" +
  220. "interval_pl_timetz|interval_recv|interval_send|interval_smaller|interval_transform|" +
  221. "interval_um|intervaltypmodin|intervaltypmodout|intinterval|isclosed|isempty|isfinite|" +
  222. "ishorizontal|iso8859_1_to_utf8|iso8859_to_utf8|iso_to_koi8r|iso_to_mic|iso_to_win1251|" +
  223. "iso_to_win866|isopen|isparallel|isperp|isvertical|johab_to_utf8|json_agg|" +
  224. "json_agg_finalfn|json_agg_transfn|json_array_element|json_array_element_text|" +
  225. "json_array_elements|json_array_length|json_each|json_each_text|json_extract_path|" +
  226. "json_extract_path_op|json_extract_path_text|json_extract_path_text_op|json_in|" +
  227. "json_object_field|json_object_field_text|json_object_keys|json_out|" +
  228. "json_populate_record|json_populate_recordset|json_recv|json_send|justify_days|" +
  229. "justify_hours|justify_interval|koi8r_to_iso|koi8r_to_mic|koi8r_to_utf8|" +
  230. "koi8r_to_win1251|koi8r_to_win866|koi8u_to_utf8|lag|language_handler_in|" +
  231. "language_handler_out|last_value|lastval|latin1_to_mic|latin2_to_mic|latin2_to_win1250|" +
  232. "latin3_to_mic|latin4_to_mic|lead|left|length|like|like_escape|likejoinsel|likesel|line|" +
  233. "line_distance|line_eq|line_horizontal|line_in|line_interpt|line_intersect|line_out|" +
  234. "line_parallel|line_perp|line_recv|line_send|line_vertical|ln|lo_close|lo_creat|lo_create|" +
  235. "lo_export|lo_import|lo_lseek|lo_lseek64|lo_open|lo_tell|lo_tell64|lo_truncate|" +
  236. "lo_truncate64|lo_unlink|log|loread|lower|lower_inc|lower_inf|lowrite|lpad|lseg|lseg_center|" +
  237. "lseg_distance|lseg_eq|lseg_ge|lseg_gt|lseg_horizontal|lseg_in|lseg_interpt|" +
  238. "lseg_intersect|lseg_le|lseg_length|lseg_lt|lseg_ne|lseg_out|lseg_parallel|lseg_perp|" +
  239. "lseg_recv|lseg_send|lseg_vertical|ltrim|macaddr_and|macaddr_cmp|macaddr_eq|macaddr_ge|" +
  240. "macaddr_gt|macaddr_in|macaddr_le|macaddr_lt|macaddr_ne|macaddr_not|macaddr_or|" +
  241. "macaddr_out|macaddr_recv|macaddr_send|makeaclitem|masklen|max|md5|mic_to_ascii|" +
  242. "mic_to_big5|mic_to_euc_cn|mic_to_euc_jp|mic_to_euc_kr|mic_to_euc_tw|mic_to_iso|" +
  243. "mic_to_koi8r|mic_to_latin1|mic_to_latin2|mic_to_latin3|mic_to_latin4|mic_to_sjis|" +
  244. "mic_to_win1250|mic_to_win1251|mic_to_win866|min|mktinterval|mod|money|mul_d_interval|" +
  245. "name|nameeq|namege|namegt|nameiclike|nameicnlike|nameicregexeq|nameicregexne|namein|" +
  246. "namele|namelike|namelt|namene|namenlike|nameout|namerecv|nameregexeq|nameregexne|namesend|" +
  247. "neqjoinsel|neqsel|netmask|network|network_cmp|network_eq|network_ge|network_gt|" +
  248. "network_le|network_lt|network_ne|network_sub|network_subeq|network_sup|network_supeq|" +
  249. "nextval|nlikejoinsel|nlikesel|notlike|now|npoints|nth_value|ntile|numeric_abs|" +
  250. "numeric_accum|numeric_add|numeric_avg|numeric_avg_accum|numeric_cmp|numeric_div|" +
  251. "numeric_div_trunc|numeric_eq|numeric_exp|numeric_fac|numeric_ge|numeric_gt|numeric_in|" +
  252. "numeric_inc|numeric_larger|numeric_le|numeric_ln|numeric_log|numeric_lt|numeric_mod|" +
  253. "numeric_mul|numeric_ne|numeric_out|numeric_power|numeric_recv|numeric_send|" +
  254. "numeric_smaller|numeric_sqrt|numeric_stddev_pop|numeric_stddev_samp|numeric_sub|" +
  255. "numeric_transform|numeric_uminus|numeric_uplus|numeric_var_pop|numeric_var_samp|" +
  256. "numerictypmodin|numerictypmodout|numnode|numrange|numrange_subdiff|obj_description|" +
  257. "octet_length|oid|oideq|oidge|oidgt|oidin|oidlarger|oidle|oidlt|oidne|oidout|oidrecv|oidsend|" +
  258. "oidsmaller|oidvectoreq|oidvectorge|oidvectorgt|oidvectorin|oidvectorle|oidvectorlt|" +
  259. "oidvectorne|oidvectorout|oidvectorrecv|oidvectorsend|oidvectortypes|on_pb|on_pl|" +
  260. "on_ppath|on_ps|on_sb|on_sl|opaque_in|opaque_out|overlaps|overlay|path|path_add|path_add_pt|" +
  261. "path_center|path_contain_pt|path_distance|path_div_pt|path_in|path_inter|path_length|" +
  262. "path_mul_pt|path_n_eq|path_n_ge|path_n_gt|path_n_le|path_n_lt|path_npoints|path_out|" +
  263. "path_recv|path_send|path_sub_pt|pclose|percent_rank|pg_advisory_lock|" +
  264. "pg_advisory_lock_shared|pg_advisory_unlock|pg_advisory_unlock_all|" +
  265. "pg_advisory_unlock_shared|pg_advisory_xact_lock|pg_advisory_xact_lock_shared|" +
  266. "pg_available_extension_versions|pg_available_extensions|pg_backend_pid|" +
  267. "pg_backup_start_time|pg_cancel_backend|pg_char_to_encoding|pg_client_encoding|" +
  268. "pg_collation_for|pg_collation_is_visible|pg_column_is_updatable|pg_column_size|" +
  269. "pg_conf_load_time|pg_conversion_is_visible|pg_create_restore_point|" +
  270. "pg_current_xlog_insert_location|pg_current_xlog_location|pg_cursor|pg_database_size|" +
  271. "pg_describe_object|pg_encoding_max_length|pg_encoding_to_char|" +
  272. "pg_event_trigger_dropped_objects|pg_export_snapshot|pg_extension_config_dump|" +
  273. "pg_extension_update_paths|pg_function_is_visible|pg_get_constraintdef|pg_get_expr|" +
  274. "pg_get_function_arguments|pg_get_function_identity_arguments|" +
  275. "pg_get_function_result|pg_get_functiondef|pg_get_indexdef|pg_get_keywords|" +
  276. "pg_get_multixact_members|pg_get_ruledef|pg_get_serial_sequence|pg_get_triggerdef|" +
  277. "pg_get_userbyid|pg_get_viewdef|pg_has_role|pg_identify_object|pg_indexes_size|" +
  278. "pg_is_in_backup|pg_is_in_recovery|pg_is_other_temp_schema|pg_is_xlog_replay_paused|" +
  279. "pg_last_xact_replay_timestamp|pg_last_xlog_receive_location|" +
  280. "pg_last_xlog_replay_location|pg_listening_channels|pg_lock_status|pg_ls_dir|" +
  281. "pg_my_temp_schema|pg_node_tree_in|pg_node_tree_out|pg_node_tree_recv|" +
  282. "pg_node_tree_send|pg_notify|pg_opclass_is_visible|pg_operator_is_visible|" +
  283. "pg_opfamily_is_visible|pg_options_to_table|pg_postmaster_start_time|" +
  284. "pg_prepared_statement|pg_prepared_xact|pg_read_binary_file|pg_read_file|" +
  285. "pg_relation_filenode|pg_relation_filepath|pg_relation_is_updatable|pg_relation_size|" +
  286. "pg_reload_conf|pg_rotate_logfile|pg_sequence_parameters|pg_show_all_settings|" +
  287. "pg_size_pretty|pg_sleep|pg_start_backup|pg_stat_clear_snapshot|pg_stat_file|" +
  288. "pg_stat_get_activity|pg_stat_get_analyze_count|pg_stat_get_autoanalyze_count|" +
  289. "pg_stat_get_autovacuum_count|pg_stat_get_backend_activity|" +
  290. "pg_stat_get_backend_activity_start|pg_stat_get_backend_client_addr|" +
  291. "pg_stat_get_backend_client_port|pg_stat_get_backend_dbid|pg_stat_get_backend_idset|" +
  292. "pg_stat_get_backend_pid|pg_stat_get_backend_start|pg_stat_get_backend_userid|" +
  293. "pg_stat_get_backend_waiting|pg_stat_get_backend_xact_start|" +
  294. "pg_stat_get_bgwriter_buf_written_checkpoints|" +
  295. "pg_stat_get_bgwriter_buf_written_clean|pg_stat_get_bgwriter_maxwritten_clean|" +
  296. "pg_stat_get_bgwriter_requested_checkpoints|pg_stat_get_bgwriter_stat_reset_time|" +
  297. "pg_stat_get_bgwriter_timed_checkpoints|pg_stat_get_blocks_fetched|" +
  298. "pg_stat_get_blocks_hit|pg_stat_get_buf_alloc|pg_stat_get_buf_fsync_backend|" +
  299. "pg_stat_get_buf_written_backend|pg_stat_get_checkpoint_sync_time|" +
  300. "pg_stat_get_checkpoint_write_time|pg_stat_get_db_blk_read_time|" +
  301. "pg_stat_get_db_blk_write_time|pg_stat_get_db_blocks_fetched|" +
  302. "pg_stat_get_db_blocks_hit|pg_stat_get_db_conflict_all|" +
  303. "pg_stat_get_db_conflict_bufferpin|pg_stat_get_db_conflict_lock|" +
  304. "pg_stat_get_db_conflict_snapshot|pg_stat_get_db_conflict_startup_deadlock|" +
  305. "pg_stat_get_db_conflict_tablespace|pg_stat_get_db_deadlocks|" +
  306. "pg_stat_get_db_numbackends|pg_stat_get_db_stat_reset_time|" +
  307. "pg_stat_get_db_temp_bytes|pg_stat_get_db_temp_files|pg_stat_get_db_tuples_deleted|" +
  308. "pg_stat_get_db_tuples_fetched|pg_stat_get_db_tuples_inserted|" +
  309. "pg_stat_get_db_tuples_returned|pg_stat_get_db_tuples_updated|" +
  310. "pg_stat_get_db_xact_commit|pg_stat_get_db_xact_rollback|pg_stat_get_dead_tuples|" +
  311. "pg_stat_get_function_calls|pg_stat_get_function_self_time|" +
  312. "pg_stat_get_function_total_time|pg_stat_get_last_analyze_time|" +
  313. "pg_stat_get_last_autoanalyze_time|pg_stat_get_last_autovacuum_time|" +
  314. "pg_stat_get_last_vacuum_time|pg_stat_get_live_tuples|pg_stat_get_numscans|" +
  315. "pg_stat_get_tuples_deleted|pg_stat_get_tuples_fetched|" +
  316. "pg_stat_get_tuples_hot_updated|pg_stat_get_tuples_inserted|" +
  317. "pg_stat_get_tuples_returned|pg_stat_get_tuples_updated|pg_stat_get_vacuum_count|" +
  318. "pg_stat_get_wal_senders|pg_stat_get_xact_blocks_fetched|" +
  319. "pg_stat_get_xact_blocks_hit|pg_stat_get_xact_function_calls|" +
  320. "pg_stat_get_xact_function_self_time|pg_stat_get_xact_function_total_time|" +
  321. "pg_stat_get_xact_numscans|pg_stat_get_xact_tuples_deleted|" +
  322. "pg_stat_get_xact_tuples_fetched|pg_stat_get_xact_tuples_hot_updated|" +
  323. "pg_stat_get_xact_tuples_inserted|pg_stat_get_xact_tuples_returned|" +
  324. "pg_stat_get_xact_tuples_updated|pg_stat_reset|pg_stat_reset_shared|" +
  325. "pg_stat_reset_single_function_counters|pg_stat_reset_single_table_counters|" +
  326. "pg_stop_backup|pg_switch_xlog|pg_table_is_visible|pg_table_size|" +
  327. "pg_tablespace_databases|pg_tablespace_location|pg_tablespace_size|" +
  328. "pg_terminate_backend|pg_timezone_abbrevs|pg_timezone_names|pg_total_relation_size|" +
  329. "pg_trigger_depth|pg_try_advisory_lock|pg_try_advisory_lock_shared|" +
  330. "pg_try_advisory_xact_lock|pg_try_advisory_xact_lock_shared|pg_ts_config_is_visible|" +
  331. "pg_ts_dict_is_visible|pg_ts_parser_is_visible|pg_ts_template_is_visible|" +
  332. "pg_type_is_visible|pg_typeof|pg_xlog_location_diff|pg_xlog_replay_pause|" +
  333. "pg_xlog_replay_resume|pg_xlogfile_name|pg_xlogfile_name_offset|pi|plainto_tsquery|" +
  334. "plpgsql_call_handler|plpgsql_inline_handler|plpgsql_validator|point|point_above|" +
  335. "point_add|point_below|point_distance|point_div|point_eq|point_horiz|point_in|point_left|" +
  336. "point_mul|point_ne|point_out|point_recv|point_right|point_send|point_sub|point_vert|" +
  337. "poly_above|poly_below|poly_center|poly_contain|poly_contain_pt|poly_contained|" +
  338. "poly_distance|poly_in|poly_left|poly_npoints|poly_out|poly_overabove|poly_overbelow|" +
  339. "poly_overlap|poly_overleft|poly_overright|poly_recv|poly_right|poly_same|poly_send|" +
  340. "polygon|popen|position|positionjoinsel|positionsel|postgresql_fdw_validator|pow|power|" +
  341. "prsd_end|prsd_headline|prsd_lextype|prsd_nexttoken|prsd_start|pt_contained_circle|" +
  342. "pt_contained_poly|query_to_xml|query_to_xml_and_xmlschema|query_to_xmlschema|" +
  343. "querytree|quote_ident|quote_literal|quote_nullable|radians|radius|random|range_adjacent|" +
  344. "range_after|range_before|range_cmp|range_contained_by|range_contains|" +
  345. "range_contains_elem|range_eq|range_ge|range_gist_compress|range_gist_consistent|" +
  346. "range_gist_decompress|range_gist_penalty|range_gist_picksplit|range_gist_same|" +
  347. "range_gist_union|range_gt|range_in|range_intersect|range_le|range_lt|range_minus|" +
  348. "range_ne|range_out|range_overlaps|range_overleft|range_overright|range_recv|range_send|" +
  349. "range_typanalyze|range_union|rangesel|rank|record_eq|record_ge|record_gt|record_in|" +
  350. "record_le|record_lt|record_ne|record_out|record_recv|record_send|regclass|regclassin|" +
  351. "regclassout|regclassrecv|regclasssend|regconfigin|regconfigout|regconfigrecv|" +
  352. "regconfigsend|regdictionaryin|regdictionaryout|regdictionaryrecv|regdictionarysend|" +
  353. "regexeqjoinsel|regexeqsel|regexnejoinsel|regexnesel|regexp_matches|regexp_replace|" +
  354. "regexp_split_to_array|regexp_split_to_table|regoperatorin|regoperatorout|" +
  355. "regoperatorrecv|regoperatorsend|regoperin|regoperout|regoperrecv|regopersend|" +
  356. "regprocedurein|regprocedureout|regprocedurerecv|regproceduresend|regprocin|regprocout|" +
  357. "regprocrecv|regprocsend|regr_avgx|regr_avgy|regr_count|regr_intercept|regr_r2|" +
  358. "regr_slope|regr_sxx|regr_sxy|regr_syy|regtypein|regtypeout|regtyperecv|regtypesend|" +
  359. "reltime|reltimeeq|reltimege|reltimegt|reltimein|reltimele|reltimelt|reltimene|reltimeout|" +
  360. "reltimerecv|reltimesend|repeat|replace|reverse|right|round|row_number|row_to_json|rpad|" +
  361. "rtrim|scalargtjoinsel|scalargtsel|scalarltjoinsel|scalarltsel|schema_to_xml|" +
  362. "schema_to_xml_and_xmlschema|schema_to_xmlschema|session_user|set_bit|set_byte|" +
  363. "set_config|set_masklen|setseed|setval|setweight|shell_in|shell_out|" +
  364. "shift_jis_2004_to_euc_jis_2004|shift_jis_2004_to_utf8|shobj_description|sign|" +
  365. "similar_escape|sin|sjis_to_euc_jp|sjis_to_mic|sjis_to_utf8|slope|smgreq|smgrin|smgrne|" +
  366. "smgrout|spg_kd_choose|spg_kd_config|spg_kd_inner_consistent|spg_kd_picksplit|" +
  367. "spg_quad_choose|spg_quad_config|spg_quad_inner_consistent|spg_quad_leaf_consistent|" +
  368. "spg_quad_picksplit|spg_range_quad_choose|spg_range_quad_config|" +
  369. "spg_range_quad_inner_consistent|spg_range_quad_leaf_consistent|" +
  370. "spg_range_quad_picksplit|spg_text_choose|spg_text_config|spg_text_inner_consistent|" +
  371. "spg_text_leaf_consistent|spg_text_picksplit|spgbeginscan|spgbuild|spgbuildempty|" +
  372. "spgbulkdelete|spgcanreturn|spgcostestimate|spgendscan|spggetbitmap|spggettuple|" +
  373. "spginsert|spgmarkpos|spgoptions|spgrescan|spgrestrpos|spgvacuumcleanup|split_part|sqrt|" +
  374. "statement_timestamp|stddev|stddev_pop|stddev_samp|string_agg|string_agg_finalfn|" +
  375. "string_agg_transfn|string_to_array|strip|strpos|substr|substring|sum|" +
  376. "suppress_redundant_updates_trigger|table_to_xml|table_to_xml_and_xmlschema|" +
  377. "table_to_xmlschema|tan|text|text_ge|text_gt|text_larger|text_le|text_lt|text_pattern_ge|" +
  378. "text_pattern_gt|text_pattern_le|text_pattern_lt|text_smaller|textanycat|textcat|texteq|" +
  379. "texticlike|texticnlike|texticregexeq|texticregexne|textin|textlen|textlike|textne|" +
  380. "textnlike|textout|textrecv|textregexeq|textregexne|textsend|thesaurus_init|" +
  381. "thesaurus_lexize|tideq|tidge|tidgt|tidin|tidlarger|tidle|tidlt|tidne|tidout|tidrecv|tidsend|" +
  382. "tidsmaller|time_cmp|time_eq|time_ge|time_gt|time_hash|time_in|time_larger|time_le|time_lt|" +
  383. "time_mi_interval|time_mi_time|time_ne|time_out|time_pl_interval|time_recv|time_send|" +
  384. "time_smaller|time_transform|timedate_pl|timemi|timenow|timeofday|timepl|timestamp_cmp|" +
  385. "timestamp_cmp_date|timestamp_cmp_timestamptz|timestamp_eq|timestamp_eq_date|" +
  386. "timestamp_eq_timestamptz|timestamp_ge|timestamp_ge_date|timestamp_ge_timestamptz|" +
  387. "timestamp_gt|timestamp_gt_date|timestamp_gt_timestamptz|timestamp_hash|timestamp_in|" +
  388. "timestamp_larger|timestamp_le|timestamp_le_date|timestamp_le_timestamptz|" +
  389. "timestamp_lt|timestamp_lt_date|timestamp_lt_timestamptz|timestamp_mi|" +
  390. "timestamp_mi_interval|timestamp_ne|timestamp_ne_date|timestamp_ne_timestamptz|" +
  391. "timestamp_out|timestamp_pl_interval|timestamp_recv|timestamp_send|timestamp_smaller|" +
  392. "timestamp_sortsupport|timestamp_transform|timestamptypmodin|timestamptypmodout|" +
  393. "timestamptz_cmp|timestamptz_cmp_date|timestamptz_cmp_timestamp|timestamptz_eq|" +
  394. "timestamptz_eq_date|timestamptz_eq_timestamp|timestamptz_ge|timestamptz_ge_date|" +
  395. "timestamptz_ge_timestamp|timestamptz_gt|timestamptz_gt_date|" +
  396. "timestamptz_gt_timestamp|timestamptz_in|timestamptz_larger|timestamptz_le|" +
  397. "timestamptz_le_date|timestamptz_le_timestamp|timestamptz_lt|timestamptz_lt_date|" +
  398. "timestamptz_lt_timestamp|timestamptz_mi|timestamptz_mi_interval|timestamptz_ne|" +
  399. "timestamptz_ne_date|timestamptz_ne_timestamp|timestamptz_out|" +
  400. "timestamptz_pl_interval|timestamptz_recv|timestamptz_send|timestamptz_smaller|" +
  401. "timestamptztypmodin|timestamptztypmodout|timetypmodin|timetypmodout|timetz_cmp|" +
  402. "timetz_eq|timetz_ge|timetz_gt|timetz_hash|timetz_in|timetz_larger|timetz_le|timetz_lt|" +
  403. "timetz_mi_interval|timetz_ne|timetz_out|timetz_pl_interval|timetz_recv|timetz_send|" +
  404. "timetz_smaller|timetzdate_pl|timetztypmodin|timetztypmodout|timezone|tinterval|" +
  405. "tintervalct|tintervalend|tintervaleq|tintervalge|tintervalgt|tintervalin|tintervalle|" +
  406. "tintervalleneq|tintervallenge|tintervallengt|tintervallenle|tintervallenlt|" +
  407. "tintervallenne|tintervallt|tintervalne|tintervalout|tintervalov|tintervalrecv|" +
  408. "tintervalrel|tintervalsame|tintervalsend|tintervalstart|to_ascii|to_char|to_date|to_hex|" +
  409. "to_json|to_number|to_timestamp|to_tsquery|to_tsvector|transaction_timestamp|translate|" +
  410. "trigger_in|trigger_out|trunc|ts_debug|ts_headline|ts_lexize|ts_match_qv|ts_match_tq|" +
  411. "ts_match_tt|ts_match_vq|ts_parse|ts_rank|ts_rank_cd|ts_rewrite|ts_stat|ts_token_type|" +
  412. "ts_typanalyze|tsmatchjoinsel|tsmatchsel|tsq_mcontained|tsq_mcontains|tsquery_and|" +
  413. "tsquery_cmp|tsquery_eq|tsquery_ge|tsquery_gt|tsquery_le|tsquery_lt|tsquery_ne|" +
  414. "tsquery_not|tsquery_or|tsqueryin|tsqueryout|tsqueryrecv|tsquerysend|tsrange|" +
  415. "tsrange_subdiff|tstzrange|tstzrange_subdiff|tsvector_cmp|tsvector_concat|tsvector_eq|" +
  416. "tsvector_ge|tsvector_gt|tsvector_le|tsvector_lt|tsvector_ne|tsvector_update_trigger|" +
  417. "tsvector_update_trigger_column|tsvectorin|tsvectorout|tsvectorrecv|tsvectorsend|" +
  418. "txid_current|txid_current_snapshot|txid_snapshot_in|txid_snapshot_out|" +
  419. "txid_snapshot_recv|txid_snapshot_send|txid_snapshot_xip|txid_snapshot_xmax|" +
  420. "txid_snapshot_xmin|txid_visible_in_snapshot|uhc_to_utf8|unique_key_recheck|unknownin|" +
  421. "unknownout|unknownrecv|unknownsend|unnest|upper|upper_inc|upper_inf|utf8_to_ascii|" +
  422. "utf8_to_big5|utf8_to_euc_cn|utf8_to_euc_jis_2004|utf8_to_euc_jp|utf8_to_euc_kr|" +
  423. "utf8_to_euc_tw|utf8_to_gb18030|utf8_to_gbk|utf8_to_iso8859|utf8_to_iso8859_1|" +
  424. "utf8_to_johab|utf8_to_koi8r|utf8_to_koi8u|utf8_to_shift_jis_2004|utf8_to_sjis|" +
  425. "utf8_to_uhc|utf8_to_win|uuid_cmp|uuid_eq|uuid_ge|uuid_gt|uuid_hash|uuid_in|uuid_le|" +
  426. "uuid_lt|uuid_ne|uuid_out|uuid_recv|uuid_send|var_pop|var_samp|varbit_in|varbit_out|" +
  427. "varbit_recv|varbit_send|varbit_transform|varbitcmp|varbiteq|varbitge|varbitgt|varbitle|" +
  428. "varbitlt|varbitne|varbittypmodin|varbittypmodout|varchar_transform|varcharin|" +
  429. "varcharout|varcharrecv|varcharsend|varchartypmodin|varchartypmodout|variance|version|" +
  430. "void_in|void_out|void_recv|void_send|width|width_bucket|win1250_to_latin2|" +
  431. "win1250_to_mic|win1251_to_iso|win1251_to_koi8r|win1251_to_mic|win1251_to_win866|" +
  432. "win866_to_iso|win866_to_koi8r|win866_to_mic|win866_to_win1251|win_to_utf8|xideq|" +
  433. "xideqint4|xidin|xidout|xidrecv|xidsend|xml|xml_in|xml_is_well_formed|" +
  434. "xml_is_well_formed_content|xml_is_well_formed_document|xml_out|xml_recv|xml_send|" +
  435. "xmlagg|xmlcomment|xmlconcat2|xmlexists|xmlvalidate|xpath|xpath_exists"
  436. );
  437. var keywordMapper = this.createKeywordMapper({
  438. "support.function": builtinFunctions,
  439. "keyword": keywords
  440. }, "identifier", true);
  441. var sqlRules = [{
  442. token : "string", // single line string -- assume dollar strings if multi-line for now
  443. regex : "['](?:(?:\\\\.)|(?:[^'\\\\]))*?[']"
  444. }, {
  445. token : "variable.language", // pg identifier
  446. regex : '".*?"'
  447. }, {
  448. token : "constant.numeric", // float
  449. regex : "[+-]?\\d+(?:(?:\\.\\d*)?(?:[eE][+-]?\\d+)?)?\\b"
  450. }, {
  451. token : keywordMapper,
  452. regex : "[a-zA-Z_][a-zA-Z0-9_$]*\\b" // TODO - Unicode in identifiers
  453. }, {
  454. token : "keyword.operator",
  455. regex : "!|!!|!~|!~\\*|!~~|!~~\\*|#|##|#<|#<=|#<>|#=|#>|#>=|%|\\&|\\&\\&|\\&<|\\&<\\||\\&>|\\*|\\+|" +
  456. "\\-|/|<|<#>|<\\->|<<|<<=|<<\\||<=|<>|<\\?>|<@|<\\^|=|>|>=|>>|>>=|>\\^|\\?#|\\?\\-|\\?\\-\\||" +
  457. "\\?\\||\\?\\|\\||@|@\\-@|@>|@@|@@@|\\^|\\||\\|\\&>|\\|/|\\|>>|\\|\\||\\|\\|/|~|~\\*|~<=~|~<~|" +
  458. "~=|~>=~|~>~|~~|~~\\*"
  459. }, {
  460. token : "paren.lparen",
  461. regex : "[\\(]"
  462. }, {
  463. token : "paren.rparen",
  464. regex : "[\\)]"
  465. }, {
  466. token : "text",
  467. regex : "\\s+"
  468. }
  469. ];
  470. this.$rules = {
  471. "start" : [{
  472. token : "comment",
  473. regex : "--.*$"
  474. },
  475. DocCommentHighlightRules.getStartRule("doc-start"),
  476. {
  477. token : "comment", // multi-line comment
  478. regex : "\\/\\*",
  479. next : "comment"
  480. },{
  481. token : "keyword.statementBegin",
  482. regex : "^[a-zA-Z]+", // Could enumerate starting keywords but this allows things to work when new statements are added.
  483. next : "statement"
  484. },{
  485. token : "support.buildin", // psql directive
  486. regex : "^\\\\[\\S]+.*$"
  487. }
  488. ],
  489. "statement" : [{
  490. token : "comment",
  491. regex : "--.*$"
  492. }, {
  493. token : "comment", // multi-line comment
  494. regex : "\\/\\*",
  495. next : "commentStatement"
  496. }, {
  497. token : "statementEnd",
  498. regex : ";",
  499. next : "start"
  500. }, {
  501. token : "string",
  502. regex : "\\$perl\\$",
  503. next : "perl-start"
  504. }, {
  505. token : "string",
  506. regex : "\\$python\\$",
  507. next : "python-start"
  508. }, {
  509. token : "string",
  510. regex : "\\$json\\$",
  511. next : "json-start"
  512. }, {
  513. token : "string",
  514. regex : "\\$(js|javascript)\\$",
  515. next : "javascript-start"
  516. }, {
  517. token : "string",
  518. regex : "\\$[\\w_0-9]*\\$$", // dollar quote at the end of a line
  519. next : "dollarSql"
  520. }, {
  521. token : "string",
  522. regex : "\\$[\\w_0-9]*\\$",
  523. next : "dollarStatementString"
  524. }
  525. ].concat(sqlRules),
  526. "dollarSql" : [{
  527. token : "comment",
  528. regex : "--.*$"
  529. }, {
  530. token : "comment", // multi-line comment
  531. regex : "\\/\\*",
  532. next : "commentDollarSql"
  533. }, {
  534. token : "string", // end quoting with dollar at the start of a line
  535. regex : "^\\$[\\w_0-9]*\\$",
  536. next : "statement"
  537. }, {
  538. token : "string",
  539. regex : "\\$[\\w_0-9]*\\$",
  540. next : "dollarSqlString"
  541. }
  542. ].concat(sqlRules),
  543. "comment" : [{
  544. token : "comment", // closing comment
  545. regex : ".*?\\*\\/",
  546. next : "start"
  547. }, {
  548. token : "comment", // comment spanning whole line
  549. regex : ".+"
  550. }
  551. ],
  552. "commentStatement" : [{
  553. token : "comment", // closing comment
  554. regex : ".*?\\*\\/",
  555. next : "statement"
  556. }, {
  557. token : "comment", // comment spanning whole line
  558. regex : ".+"
  559. }
  560. ],
  561. "commentDollarSql" : [{
  562. token : "comment", // closing comment
  563. regex : ".*?\\*\\/",
  564. next : "dollarSql"
  565. }, {
  566. token : "comment", // comment spanning whole line
  567. regex : ".+"
  568. }
  569. ],
  570. "dollarStatementString" : [{
  571. token : "string", // closing dollarstring
  572. regex : ".*?\\$[\\w_0-9]*\\$",
  573. next : "statement"
  574. }, {
  575. token : "string", // dollarstring spanning whole line
  576. regex : ".+"
  577. }
  578. ],
  579. "dollarSqlString" : [{
  580. token : "string", // closing dollarstring
  581. regex : ".*?\\$[\\w_0-9]*\\$",
  582. next : "dollarSql"
  583. }, {
  584. token : "string", // dollarstring spanning whole line
  585. regex : ".+"
  586. }
  587. ]
  588. };
  589. this.embedRules(DocCommentHighlightRules, "doc-", [ DocCommentHighlightRules.getEndRule("start") ]);
  590. this.embedRules(PerlHighlightRules, "perl-", [{token : "string", regex : "\\$perl\\$", next : "statement"}]);
  591. this.embedRules(PythonHighlightRules, "python-", [{token : "string", regex : "\\$python\\$", next : "statement"}]);
  592. this.embedRules(JsonHighlightRules, "json-", [{token : "string", regex : "\\$json\\$", next : "statement"}]);
  593. this.embedRules(JavaScriptHighlightRules, "javascript-", [{token : "string", regex : "\\$(js|javascript)\\$", next : "statement"}]);
  594. };
  595. oop.inherits(PgsqlHighlightRules, TextHighlightRules);
  596. exports.PgsqlHighlightRules = PgsqlHighlightRules;
  597. });