| -- |
| -- COMMENTS |
| -- |
| SELECT 'trailing' AS first; -- trailing single line |
| first |
| ---------- |
| trailing |
| (1 row) |
| |
| SELECT /* embedded single line */ 'embedded' AS second; |
| second |
| ---------- |
| embedded |
| (1 row) |
| |
| SELECT /* both embedded and trailing single line */ 'both' AS third; -- trailing single line |
| third |
| ------- |
| both |
| (1 row) |
| |
| SELECT 'before multi-line' AS fourth; |
| fourth |
| ------------------- |
| before multi-line |
| (1 row) |
| |
| /* This is an example of SQL which should not execute: |
| * select 'multi-line'; |
| */ |
| SELECT 'after multi-line' AS fifth; |
| fifth |
| ------------------ |
| after multi-line |
| (1 row) |
| |
| -- |
| -- Nested comments |
| -- |
| /* |
| SELECT 'trailing' as x1; -- inside block comment |
| */ |
| /* This block comment surrounds a query which itself has a block comment... |
| SELECT /* embedded single line */ 'embedded' AS x2; |
| */ |
| SELECT -- continued after the following block comments... |
| /* Deeply nested comment. |
| This includes a single apostrophe to make sure we aren't decoding this part as a string. |
| SELECT 'deep nest' AS n1; |
| /* Second level of nesting... |
| SELECT 'deeper nest' as n2; |
| /* Third level of nesting... |
| SELECT 'deepest nest' as n3; |
| */ |
| Hoo boy. Still two deep... |
| */ |
| Now just one deep... |
| */ |
| 'deeply nested example' AS sixth; |
| sixth |
| ----------------------- |
| deeply nested example |
| (1 row) |
| |
| /* and this is the end of the file */ |