...................................................................................1530 SECURITY LABEL.................................................................................................. DESC, which is not the same as ORDER BY x DESC, y DESC. A sort_expression can also be the column label or number of an output column, as in: SELECT a + b AS sum, c FROM table1 ORDER BY sum; SELECT a, recognize a cycle. This allows a simple array rather than a composite-type array to be used, gaining efficiency. Tip: The recursive query evaluation algorithm produces its output in breadth-first search order

...................................................................................1633 SECURITY LABEL.................................................................................................. DESC, which is not the same as ORDER BY x DESC, y DESC. A sort_expression can also be the column label or number of an output column, as in: SELECT a + b AS sum, c FROM table1 ORDER BY sum; SELECT a, recognize a cycle. This allows a simple array rather than a composite-type array to be used, gaining efficiency. 111 Chapter 7. Queries Tip: The recursive query evaluation algorithm produces its output in

...................................................................................1474 SECURITY LABEL.................................................................................................. choose to do something different. 97 Chapter 7. Queries A sort_expression can also be the column label or number of an output column, as in: SELECT a + b AS sum, c FROM table1 ORDER BY sum; SELECT a, recognize a cycle. This allows a simple array rather than a composite-type array to be used, gaining efficiency. Tip: The recursive query evaluation algorithm produces its output in breadth-first search order

...................................................................................1578 SECURITY LABEL.................................................................................................. DESC, which is not the same as ORDER BY x DESC, y DESC. A sort_expression can also be the column label or number of an output column, as in: 1. Actually, PostgreSQL uses the default B-tree operator class recognize a cycle. This allows a simple array rather than a composite-type array to be used, gaining efficiency. Tip: The recursive query evaluation algorithm produces its output in breadth-first search order

...................................................................................1426 SECURITY LABEL.................................................................................................. DESC, which is not the same as ORDER BY x DESC, y DESC. A sort_expression can also be the column label or number of an output column, as in: SELECT a + b AS sum, c FROM table1 ORDER BY sum; SELECT a, recognize a cycle. This allows a simple array rather than a composite-type array to be used, gaining efficiency. Tip: The recursive query evaluation algorithm produces its output in breadth-first search order

...................................................................................1524 SECURITY LABEL.................................................................................................. DESC, which is not the same as ORDER BY x DESC, y DESC. A sort_expression can also be the column label or number of an output column, as in: 1. Actually, PostgreSQL uses the default B-tree operator class recognize a cycle. This allows a simple array rather than a composite-type array to be used, gaining efficiency. Tip: The recursive query evaluation algorithm produces its output in breadth-first search order

DESC, which is not the same as ORDER BY x DESC, y DESC. A sort_expression can also be the column label or number of an output column, as in: SELECT a + b AS sum, c FROM table1 ORDER BY sum; 1. Actually recognize a cycle. This allows a simple array rather than a composite-type array to be used, gaining efficiency. Tip: The recursive query evaluation algorithm produces its output in breadth-first search order Implementation Details An enum value occupies four bytes on disk. The length of an enum value’s textual label is limited by the NAMEDATALEN setting compiled into PostgreSQL; in standard builds this means at most

choose to do something different. 95 Chapter 7. Queries A sort_expression can also be the column label or number of an output column, as in: SELECT a + b AS sum, c FROM table1 ORDER BY sum; SELECT a, recognize a cycle. This allows a simple array rather than a composite-type array to be used, gaining efficiency. Tip: The recursive query evaluation algorithm produces its output in breadth-first search order Implementation Details An enum value occupies four bytes on disk. The length of an enum value’s textual label is limited by the NAMEDATALEN setting compiled into PostgreSQL; in standard builds this means at most

DESC, which is not the same as ORDER BY x DESC, y DESC. A sort_expression can also be the column label or number of an output column, as in: SELECT a + b AS sum, c FROM table1 ORDER BY sum; SELECT a, recognize a cycle. This allows a simple array rather than a composite-type array to be used, gaining efficiency. Tip: The recursive query evaluation algorithm produces its output in breadth-first search order Implementation Details An enum value occupies four bytes on disk. The length of an enum value’s textual label is limited by the NAMEDATALEN setting compiled into PostgreSQL; in standard builds this means at most

DESC, which is not the same as ORDER BY x DESC, y DESC. A sort_expression can also be the column label or number of an output column, as in: SELECT a + b AS sum, c FROM table1 ORDER BY sum; SELECT a, recognize a cycle. This allows a simple array rather than a composite-type array to be used, gaining efficiency. Tip: The recursive query evaluation algorithm produces its output in breadth-first search order Implementation Details An enum value occupies four bytes on disk. The length of an enum value’s textual label is limited by the NAMEDATALEN setting compiled into PostgreSQL; in standard builds this means at most