@@ -1253,8 +1253,8 @@ ROLLUP ( <replaceable>e1</>, <replaceable>e2</>, <replaceable>e3</>, ... )
1253
1253
GROUPING SETS (
1254
1254
( <replaceable>e1</>, <replaceable>e2</>, <replaceable>e3</>, ... ),
1255
1255
...
1256
- ( <replaceable>e1</>, <replaceable>e2</> )
1257
- ( <replaceable>e1</> )
1256
+ ( <replaceable>e1</>, <replaceable>e2</> ),
1257
+ ( <replaceable>e1</> ),
1258
1258
( )
1259
1259
)
1260
1260
</programlisting>
@@ -1282,7 +1282,7 @@ GROUPING SETS (
1282
1282
( b, c ),
1283
1283
( b ),
1284
1284
( c ),
1285
- ( ),
1285
+ ( )
1286
1286
)
1287
1287
</programlisting>
1288
1288
</para>
@@ -1294,27 +1294,27 @@ GROUPING SETS (
1294
1294
units for the purposes of generating the individual grouping sets.
1295
1295
For example:
1296
1296
<programlisting>
1297
- CUBE ( (a,b), (c,d) )
1297
+ CUBE ( (a, b), (c, d) )
1298
1298
</programlisting>
1299
1299
is equivalent to
1300
1300
<programlisting>
1301
1301
GROUPING SETS (
1302
- ( a, b, c, d )
1303
- ( a, b )
1304
- ( c, d )
1302
+ ( a, b, c, d ),
1303
+ ( a, b ),
1304
+ ( c, d ),
1305
1305
( )
1306
1306
)
1307
1307
</programlisting>
1308
1308
and
1309
1309
<programlisting>
1310
- ROLLUP ( a, (b,c), d )
1310
+ ROLLUP ( a, (b, c), d )
1311
1311
</programlisting>
1312
1312
is equivalent to
1313
1313
<programlisting>
1314
1314
GROUPING SETS (
1315
- ( a, b, c, d )
1316
- ( a, b, c )
1317
- ( a )
1315
+ ( a, b, c, d ),
1316
+ ( a, b, c ),
1317
+ ( a ),
1318
1318
( )
1319
1319
)
1320
1320
</programlisting>
@@ -1333,27 +1333,27 @@ GROUPING SETS (
1333
1333
clause, then the final list of grouping sets is the cross product of the
1334
1334
individual items. For example:
1335
1335
<programlisting>
1336
- GROUP BY a, CUBE(b,c), GROUPING SETS ((d), (e))
1336
+ GROUP BY a, CUBE (b, c), GROUPING SETS ((d), (e))
1337
1337
</programlisting>
1338
1338
is equivalent to
1339
1339
<programlisting>
1340
1340
GROUP BY GROUPING SETS (
1341
- (a,b,c, d), (a,b,c, e),
1342
- (a,b, d), (a,b, e),
1343
- (a,c, d), (a,c, e),
1344
- (a,d), (a,e)
1341
+ (a, b, c, d), (a, b, c, e),
1342
+ (a, b, d), (a, b, e),
1343
+ (a, c, d), (a, c, e),
1344
+ (a, d), (a, e)
1345
1345
)
1346
1346
</programlisting>
1347
1347
</para>
1348
1348
1349
1349
<note>
1350
1350
<para>
1351
- The construct <literal>(a,b)</> is normally recognized in expressions as
1351
+ The construct <literal>(a, b)</> is normally recognized in expressions as
1352
1352
a <link linkend="sql-syntax-row-constructors">row constructor</link>.
1353
1353
Within the <literal>GROUP BY</> clause, this does not apply at the top
1354
- levels of expressions, and <literal>(a,b)</> is parsed as a list of
1354
+ levels of expressions, and <literal>(a, b)</> is parsed as a list of
1355
1355
expressions as described above. If for some reason you <emphasis>need</>
1356
- a row constructor in a grouping expression, use <literal>ROW(a,b)</>.
1356
+ a row constructor in a grouping expression, use <literal>ROW(a, b)</>.
1357
1357
</para>
1358
1358
</note>
1359
1359
</sect2>