| 1 |
<!DOCTYPE html> |
| 2 |
<html><head> |
| 3 |
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/> |
| 4 |
<title>test.sql_postgres</title> |
| 5 |
<meta name="generator" content="KF5::SyntaxHighlighting - Definition (SQL (PostgreSQL)) - Theme (Breeze Dark)"/> |
| 6 |
</head><body style="background-color:#232629;color:#cfcfc2"><pre> |
| 7 |
<span style="color:#7a7c7d;">-- PostgreSQL doesn't use # as comment</span> |
| 8 |
<span style="font-weight:bold;">select</span> jsoncol <span style="color:#3f8058;">#></span> <span style="font-weight:bold;">array</span>[<span style="color:#da4453;">'p1</span><span style="color:#f44f4f;">'</span>, <span style="color:#da4453;">'p2</span><span style="color:#f44f4f;">'</span>] |
| 9 |
<span style="font-weight:bold;">from</span> some_table |
| 10 |
<span style="font-weight:bold;">where</span> col<span style="color:#3f8058;">#-</span><span style="color:#da4453;">'{1, a}</span><span style="color:#f44f4f;">'</span> <span style="color:#3f8058;">@</span>? <span style="color:#da4453;">'$.b ? (@ > 0)</span><span style="color:#f44f4f;">'</span>; |
| 11 |
|
| 12 |
<span style="font-weight:bold;">SELECT</span> |
| 13 |
|
| 14 |
<span style="color:#da4453;">'Single quoted string</span><span style="color:#f44f4f;">'</span> <span style="font-weight:bold;">AS</span> test01, |
| 15 |
<span style="color:#da4453;">'Backslashes in single-quoted strings are interpreted literally and get no highlighting: \ </span><span style="color:#f44f4f;">'</span> <span style="font-weight:bold;">AS</span> test02, |
| 16 |
<span style="color:#da4453;">'The single-quote character can be escaped by using two of them: </span><span style="color:#3daee9;">''</span><span style="color:#da4453;"> This is highlighted.</span><span style="color:#f44f4f;">'</span> <span style="font-weight:bold;">AS</span> test03, |
| 17 |
<span style="color:#da4453;">'Line breaks</span> |
| 18 |
<span style="color:#da4453;">are allowed</span><span style="color:#f44f4f;">'</span> <span style="font-weight:bold;">AS</span> test04, |
| 19 |
|
| 20 |
<span style="color:#f44f4f;">E'</span><span style="color:#f44f4f;">Escape strings are introduced with an uppercase E…</span><span style="color:#f44f4f;">'</span> <span style="font-weight:bold;">AS</span> test11, |
| 21 |
<span style="color:#f44f4f;">e'</span><span style="color:#f44f4f;">or a lowercase e.</span><span style="color:#f44f4f;">'</span> <span style="font-weight:bold;">AS</span> test12, |
| 22 |
<span style="color:#f44f4f;">E'</span><span style="color:#f44f4f;">Line breaks</span> |
| 23 |
<span style="color:#f44f4f;">are allowed</span><span style="color:#f44f4f;">'</span> <span style="font-weight:bold;">AS</span> test13, |
| 24 |
<span style="color:#f44f4f;">E'</span><span style="color:#f44f4f;">The single-quote character can be escaped by using two of them: </span><span style="color:#3daee9;">''</span><span style="color:#f44f4f;"> This is highlighted.</span><span style="color:#f44f4f;">'</span> <span style="font-weight:bold;">AS</span> test14, |
| 25 |
<span style="color:#f44f4f;">E'</span><span style="color:#f44f4f;">They can have escapes like </span><span style="color:#3daee9;">\t</span><span style="color:#f44f4f;"> or three-digit octal </span><span style="color:#3daee9;">\011</span><span style="color:#f44f4f;"> or two-digit hexadecimal </span><span style="color:#3daee9;">\x09</span><span style="color:#f44f4f;">.</span><span style="color:#f44f4f;">'</span> <span style="font-weight:bold;">AS</span> test15, |
| 26 |
<span style="color:#f44f4f;">E'</span><span style="color:#f44f4f;">Also the escape character itself and the single-quote can be escaped: </span><span style="color:#3daee9;">\\</span><span style="color:#f44f4f;"> and </span><span style="color:#3daee9;">\'</span><span style="color:#f44f4f;"> are highlighted.</span><span style="color:#f44f4f;">'</span> <span style="font-weight:bold;">AS</span> test16, |
| 27 |
<span style="color:#f44f4f;">E'</span><span style="color:#f44f4f;">Non-defined combinations: Example: </span><span style="color:#3daee9;">\y</span><span style="color:#f44f4f;"> is highlighted because it’s treated as escaped characters and substituted by “y”. Even before a line break</span><span style="color:#3daee9;">\</span> |
| 28 |
<span style="color:#f44f4f;">this is possible.</span><span style="color:#f44f4f;">'</span> <span style="font-weight:bold;">AS</span> test17, |
| 29 |
<span style="color:#f44f4f;">E'</span><span style="color:#f44f4f;">Higher Unicode code points: Hex: Four-digit </span><span style="color:#3daee9;">\u1234</span><span style="color:#f44f4f;"> and eight-digit </span><span style="color:#3daee9;">\U00001234</span><span style="color:#f44f4f;">'</span> <span style="font-weight:bold;">AS</span> test18, |
| 30 |
<span style="color:#f44f4f;">E'</span><span style="color:#f44f4f;">These escapes with “u” and “U” are the only one that are not error tolerant: </span><span style="color:#da4453;text-decoration:underline;">\u</span><span style="color:#f44f4f;">123 and </span><span style="color:#da4453;text-decoration:underline;">\u</span><span style="color:#f44f4f;">123 are highlighted as errors.</span><span style="color:#f44f4f;">'</span> <span style="font-weight:bold;">AS</span> test19, |
| 31 |
|
| 32 |
<span style="color:#f44f4f;">U&'</span><span style="color:#f44f4f;">Unicode escape strings are introduced with an uppercase U…</span><span style="color:#f44f4f;">'</span> <span style="font-weight:bold;">AS</span> test21, |
| 33 |
<span style="color:#f44f4f;">u&'</span><span style="color:#f44f4f;">or a lowercase u.</span><span style="color:#f44f4f;">'</span> <span style="font-weight:bold;">AS</span> test22, |
| 34 |
<span style="color:#f44f4f;">U&'</span><span style="color:#f44f4f;">The single-quote character can be escaped by using two of them: </span><span style="color:#3daee9;">''</span><span style="color:#f44f4f;"> This is highlighted.</span><span style="color:#f44f4f;">'</span> <span style="font-weight:bold;">AS</span> test23, |
| 35 |
<span style="color:#f44f4f;">U&'</span><span style="color:#f44f4f;">Types of escape: </span><span style="color:#3daee9;">\0061</span><span style="color:#f44f4f;"> and </span><span style="color:#3daee9;">\+000061</span><span style="color:#f44f4f;"> and </span><span style="color:#3daee9;">\\</span><span style="color:#f44f4f;">'</span> <span style="font-weight:bold;">AS</span> test24, |
| 36 |
<span style="color:#f44f4f;">U&'</span><span style="color:#f44f4f;">All other usages of </span><span style="color:#da4453;text-decoration:underline;">\</span><span style="color:#f44f4f;"> are errors, including </span><span style="color:#da4453;text-decoration:underline;">\</span><span style="color:#f44f4f;">'</span> test25, |
| 37 |
<span style="color:#f44f4f;">U&'</span><span style="color:#f44f4f;">Line breaks</span> |
| 38 |
<span style="color:#f44f4f;">are allowed</span><span style="color:#f44f4f;">'</span> <span style="font-weight:bold;">AS</span> test26, |
| 39 |
|
| 40 |
<span style="color:#f44f4f;">U&'</span><span style="color:#f44f4f;">User-defined escape characters can be used instead of \ by specifying</span><span style="color:#f44f4f;">'</span> <span style="font-weight:bold;">UESCAPE</span> <span style="color:#da4453;">'w</span><span style="color:#f44f4f;">'</span> <span style="font-weight:bold;">AS</span> test31, |
| 41 |
<span style="color:#f44f4f;">U&'</span><span style="color:#f44f4f;">Here, \ behaves as normal character. Escape sequences: </span><span style="color:#3daee9;">w0061</span><span style="color:#f44f4f;"> and </span><span style="color:#3daee9;">w+000061</span><span style="color:#f44f4f;"> and </span><span style="color:#3daee9;">ww</span><span style="color:#f44f4f;">'</span> <span style="font-weight:bold;">UESCAPE</span> <span style="color:#da4453;">'w</span><span style="color:#f44f4f;">'</span> <span style="font-weight:bold;">AS</span> test32, |
| 42 |
<span style="color:#f44f4f;">U&'</span><span style="color:#f44f4f;">Also work correctly for escape characters that have a special meaning in Regular Expressions: </span><span style="color:#3daee9;">.0061</span><span style="color:#f44f4f;"> </span><span style="color:#3daee9;">.+000061</span><span style="color:#f44f4f;"> and </span><span style="color:#3daee9;">..</span><span style="color:#f44f4f;">'</span> <span style="font-weight:bold;">UESCAPE</span> <span style="color:#da4453;">'.</span><span style="color:#f44f4f;">'</span> <span style="font-weight:bold;">AS</span> test33, |
| 43 |
|
| 44 |
<span style="color:#f67400;">0</span> <span style="font-weight:bold;">AS</span> <span style="color:#27ae60;">U&"Unicode escape identifiers are introduces with an uppercase U…"</span>, |
| 45 |
<span style="color:#f67400;">0</span> <span style="font-weight:bold;">AS</span> <span style="color:#27ae60;">u&"or a lowercase u."</span>, |
| 46 |
<span style="color:#f67400;">0</span> <span style="font-weight:bold;">AS</span> <span style="color:#27ae60;">U&"The double-quote character can be escaped by using two of them: </span><span style="color:#3daee9;">""</span><span style="color:#27ae60;"> This is highlighted."</span>, |
| 47 |
<span style="color:#f67400;">0</span> <span style="font-weight:bold;">AS</span> <span style="color:#27ae60;">U&"Types of escape: </span><span style="color:#3daee9;">\0061</span><span style="color:#27ae60;"> and </span><span style="color:#3daee9;">\+000061</span><span style="color:#27ae60;"> and </span><span style="color:#3daee9;">\\</span><span style="color:#27ae60;">"</span>, |
| 48 |
<span style="color:#f67400;">0</span> <span style="font-weight:bold;">AS</span> <span style="color:#27ae60;">U&"All other usages of </span><span style="color:#da4453;text-decoration:underline;">\</span><span style="color:#27ae60;"> are errors, including </span><span style="color:#da4453;text-decoration:underline;">\</span><span style="color:#27ae60;">"</span>, |
| 49 |
<span style="color:#f67400;">0</span> <span style="font-weight:bold;">AS</span> <span style="color:#27ae60;">U&"Line breaks</span> |
| 50 |
<span style="color:#27ae60;">are allowed"</span> |
| 51 |
|
| 52 |
<span style="color:#8e44ad;">power</span>(<span style="color:#f67400;">2</span>, <span style="color:#f67400;">3</span>) <span style="font-weight:bold;">AS</span> test31, <span style="color:#7a7c7d;">-- PostgreSQL Build-in functions (like “power”) are highlighted when followed by an opening parenthesis…</span> |
| 53 |
power <span style="font-weight:bold;">AS</span> test32, <span style="color:#f67400;">0</span> <span style="font-weight:bold;">AS</span> power, <span style="color:#7a7c7d;">-- …but not highlighted if used as identifier.</span> |
| 54 |
<span style="color:#0099ff;font-weight:bold;">ST_PointOnSurface</span>(way) <span style="font-weight:bold;">AS</span> test33, <span style="color:#7a7c7d;">-- PostGIS functions are highlighted as extensions.</span> |
| 55 |
|
| 56 |
<span style="color:#7a7c7d;">-- User-defined functions get no special highlighting:</span> |
| 57 |
testpower(<span style="color:#f67400;">2</span>, <span style="color:#f67400;">3</span>) <span style="font-weight:bold;">AS</span> test34, |
| 58 |
|
| 59 |
foo <span style="font-weight:bold;">AS</span> bar |
| 60 |
|
| 61 |
<span style="font-weight:bold;">FROM</span> mytable; |
| 62 |
</pre></body></html> |