in lib/ace/mode/redshift_highlight_rules.js [40:225]
var RedshiftHighlightRules = function() {
// Keywords, functions, operators last updated for pg 9.3.
var keywords = (
"aes128|aes256|all|allowoverwrite|analyse|analyze|and|any|array|as|asc|authorization|backup|" +
"between|binary|blanksasnull|both|bytedict|bzip2|case|cast|check|collate|column|constraint|create|credentials|" +
"cross|current_date|current_time|current_timestamp|current_user|current_user_id|default|deferrable|deflate|defrag|delta|" +
"delta32k|desc|disable|distinct|do|else|emptyasnull|enable|encode|encrypt|encryption|end|except|explicit|false|for|foreign|" +
"freeze|from|full|globaldict256|globaldict64k|grant|group|gzip|having|identity|ignore|ilike|in|initially|inner|intersect|into|is|" +
"isnull|join|leading|left|like|limit|localtime|localtimestamp|lun|luns|lzo|lzop|minus|mostly13|mostly32|mostly8|natural|new|not|notnull|" +
"null|nulls|off|offline|offset|old|on|only|open|or|order|outer|overlaps|parallel|partition|percent|permissions|placing|primary|raw|readratio|" +
"recover|references|rejectlog|resort|restore|right|select|session_user|similar|some|sysdate|system|table|tag|tdes|text255|text32k|then|timestamp|" +
"to|top|trailing|true|truncatecolumns|union|unique|user|using|verbose|wallet|when|where|with|without"
);
var builtinFunctions = (
"current_schema|current_schemas|has_database_privilege|has_schema_privilege|has_table_privilege|age|current_time|current_timestamp|localtime|" +
"isfinite|now|ascii|get_bit|get_byte|octet_length|set_bit|set_byte|to_ascii|avg|count|listagg|max|min|stddev_samp|stddev_pop|sum|var_samp|var_pop|" +
"bit_and|bit_or|bool_and|bool_or|avg|count|cume_dist|dense_rank|first_value|last_value|lag|lead|listagg|max|median|min|nth_value|ntile|percent_rank|" +
"percentile_cont|percentile_disc|rank|ratio_to_report|row_number|case|coalesce|decode|greatest|least|nvl|nvl2|nullif|add_months|age|convert_timezone|" +
"current_date|timeofday|current_time|current_timestamp|date_cmp|date_cmp_timestamp|date_part_year|dateadd|datediff|date_part|date_trunc|extract|getdate|" +
"interval_cmp|isfinite|last_day|localtime|localtimestamp|months_between|next_day|now|sysdate|timestamp_cmp|timestamp_cmp_date|trunc|abs|acos|asin|atan|" +
"atan2|cbrt|ceiling|ceil|checksum|cos|cot|degrees|dexp|dlog1|dlog10|exp|floor|ln|log|mod|pi|power|radians|random|round|sin|sign|sqrt|tan|trunc|ascii|" +
"bpcharcmp|btrim|bttext_pattern_cmp|char_length|character_length|charindex|chr|concat|crc32|func_sha1|get_bit|get_byte|initcap|left|right|len|length|" +
"lower|lpad|rpad|ltrim|md5|octet_length|position|quote_ident|quote_literal|regexp_count|regexp_instr|regexp_replace|regexp_substr|repeat|replace|replicate|" +
"reverse|rtrim|set_bit|set_byte|split_part|strpos|strtol|substring|textlen|to_ascii|to_hex|translate|trim|upper|json_array_length|json_extract_array_element_text|" +
"json_extract_path_text|cast|convert|to_char|to_date|to_number|current_database|current_schema|current_schemas|current_user|current_user_id|has_database_privilege|" +
"has_schema_privilege|has_table_privilege|pg_backend_pid|pg_last_copy_count|pg_last_copy_id|pg_last_query_id|pg_last_unload_count|session_user|slice_num|user|version"
);
var keywordMapper = this.createKeywordMapper({
"support.function": builtinFunctions,
"keyword": keywords
}, "identifier", true);
var sqlRules = [{
token : "string", // single line string -- assume dollar strings if multi-line for now
regex : "['](?:(?:\\\\.)|(?:[^'\\\\]))*?[']"
}, {
token : "variable.language", // pg identifier
regex : '".*?"'
}, {
token : "constant.numeric", // float
regex : "[+-]?\\d+(?:(?:\\.\\d*)?(?:[eE][+-]?\\d+)?)?\\b"
}, {
token : keywordMapper,
regex : "[a-zA-Z_][a-zA-Z0-9_$]*\\b" // TODO - Unicode in identifiers
}, {
token : "keyword.operator",
regex : "!|!!|!~|!~\\*|!~~|!~~\\*|#|##|#<|#<=|#<>|#=|#>|#>=|%|\\&|\\&\\&|\\&<|\\&<\\||\\&>|\\*|\\+|" +
"\\-|/|<|<#>|<\\->|<<|<<=|<<\\||<=|<>|<\\?>|<@|<\\^|=|>|>=|>>|>>=|>\\^|\\?#|\\?\\-|\\?\\-\\||" +
"\\?\\||\\?\\|\\||@|@\\-@|@>|@@|@@@|\\^|\\||\\|\\&>|\\|/|\\|>>|\\|\\||\\|\\|/|~|~\\*|~<=~|~<~|" +
"~=|~>=~|~>~|~~|~~\\*"
}, {
token : "paren.lparen",
regex : "[\\(]"
}, {
token : "paren.rparen",
regex : "[\\)]"
}, {
token : "text",
regex : "\\s+"
}
];
this.$rules = {
"start" : [{
token : "comment",
regex : "--.*$"
},
DocCommentHighlightRules.getStartRule("doc-start"),
{
token : "comment", // multi-line comment
regex : "\\/\\*",
next : "comment"
},{
token : "keyword.statementBegin",
regex : "^[a-zA-Z]+", // Could enumerate starting keywords but this allows things to work when new statements are added.
next : "statement"
},{
token : "support.buildin", // psql directive
regex : "^\\\\[\\S]+.*$"
}
],
"statement" : [{
token : "comment",
regex : "--.*$"
}, {
token : "comment", // multi-line comment
regex : "\\/\\*",
next : "commentStatement"
}, {
token : "statementEnd",
regex : ";",
next : "start"
}, {
token : "string",
regex : "\\$json\\$",
next : "json-start"
}, {
token : "string",
regex : "\\$[\\w_0-9]*\\$$", // dollar quote at the end of a line
next : "dollarSql"
}, {
token : "string",
regex : "\\$[\\w_0-9]*\\$",
next : "dollarStatementString"
}
].concat(sqlRules),
"dollarSql" : [{
token : "comment",
regex : "--.*$"
}, {
token : "comment", // multi-line comment
regex : "\\/\\*",
next : "commentDollarSql"
}, {
token : "string", // end quoting with dollar at the start of a line
regex : "^\\$[\\w_0-9]*\\$",
next : "statement"
}, {
token : "string",
regex : "\\$[\\w_0-9]*\\$",
next : "dollarSqlString"
}
].concat(sqlRules),
"comment" : [{
token : "comment", // closing comment
regex : ".*?\\*\\/",
next : "start"
}, {
token : "comment", // comment spanning whole line
regex : ".+"
}
],
"commentStatement" : [{
token : "comment", // closing comment
regex : ".*?\\*\\/",
next : "statement"
}, {
token : "comment", // comment spanning whole line
regex : ".+"
}
],
"commentDollarSql" : [{
token : "comment", // closing comment
regex : ".*?\\*\\/",
next : "dollarSql"
}, {
token : "comment", // comment spanning whole line
regex : ".+"
}
],
"dollarStatementString" : [{
token : "string", // closing dollarstring
regex : ".*?\\$[\\w_0-9]*\\$",
next : "statement"
}, {
token : "string", // dollarstring spanning whole line
regex : ".+"
}
],
"dollarSqlString" : [{
token : "string", // closing dollarstring
regex : ".*?\\$[\\w_0-9]*\\$",
next : "dollarSql"
}, {
token : "string", // dollarstring spanning whole line
regex : ".+"
}
]
};
this.embedRules(DocCommentHighlightRules, "doc-", [ DocCommentHighlightRules.getEndRule("start") ]);
this.embedRules(JsonHighlightRules, "json-", [{token : "string", regex : "\\$json\\$", next : "statement"}]);
};