inputs/postgreSQL/comments.sql

0001 --
0002 -- Portions Copyright (c) 1996-2019, PostgreSQL Global Development Group
0003 --
0004 --
0005 -- COMMENTS
0006 -- https://github.com/postgres/postgres/blob/REL_12_BETA3/src/test/regress/sql/comments.sql
0007 --
0008
0009 SELECT 'trailing' AS first; -- trailing single line
0010 SELECT /* embedded single line */ 'embedded' AS `second`;
0011 SELECT /* both embedded and trailing single line */ 'both' AS third; -- trailing single line
0012
0013 SELECT 'before multi-line' AS fourth;
0014 --QUERY-DELIMITER-START
0015 -- [SPARK-28880] ANSI SQL: Bracketed comments
0016 /* This is an example of SQL which should not execute:
0017  * select 'multi-line';
0018  */
0019 SELECT 'after multi-line' AS fifth;
0020 --QUERY-DELIMITER-END
0021
0022 -- [SPARK-28880] ANSI SQL: Bracketed comments
0023 --
0024 -- Nested comments
0025 --
0026 --QUERY-DELIMITER-START
0027 /*
0028 SELECT 'trailing' as x1; -- inside block comment
0029 */
0030
0031 /* This block comment surrounds a query which itself has a block comment...
0032 SELECT /* embedded single line */ 'embedded' AS x2;
0033 */
0034
0035 SELECT -- continued after the following block comments...
0036 /* Deeply nested comment.
0037    This includes a single apostrophe to make sure we aren't decoding this part as a string.
0038 SELECT 'deep nest' AS n1;
0039 /* Second level of nesting...
0040 SELECT 'deeper nest' as n2;
0041 /* Third level of nesting...
0042 SELECT 'deepest nest' as n3;
0043 */
0044 Hoo boy. Still two deep...
0045 */
0046 Now just one deep...
0047 */
0048 'deeply nested example' AS sixth;
0049 --QUERY-DELIMITER-END
0050 /* and this is the end of the file */