................................. 2680 F.13. dict_int — example full-text search dictionary for integers ....................... 2712 F.14. dict_xsyn — example synonym full-text search dictionary .... enumerator ......................................... 2733 F.20. intarray — manipulate arrays of integers .............................................. 2735 F.21. isn — data types for international standard (0 or 1). Hexadecimal digits and the radix prefixes can be in upper or lower case. Note that only integers can have non-decimal forms, not num- bers with fractional parts. These are some examples of valid

................................. 2823 F.13. dict_int — example full-text search dictionary for integers ............................ 2856 F.14. dict_xsyn — example synonym full-text search dictionary enumerator ............................................... 2878 F.20. intarray — manipulate arrays of integers .................................................... 2880 F.21. isn — data types for international (0 or 1). Hexadecimal digits and the radix prefixes can be in upper or lower case. Note that only integers can have non-decimal forms, not numbers with fractional parts. These are some examples of valid

................................. 2722 F.12. dict_int — example full-text search dictionary for integers ....................... 2754 F.13. dict_xsyn — example synonym full-text search dictionary .... ............ 2775 xix PostgreSQL 17beta1 Documentation F.19. intarray — manipulate arrays of integers .............................................. 2777 F.20. isn — data types for international standard (0 or 1). Hexadecimal digits and the radix prefixes can be in upper or lower case. Note that only integers can have non-decimal forms, not num- bers with fractional parts. These are some examples of valid

to the original input. 8.1. Numeric Types Numeric types consist of two-, four-, and eight-byte integers, four- and eight-byte floating-point numbers, and selectable-precision decimals. Table 8-2 lists may not function correctly on all platforms, since it relies on compiler support for eight- byte integers. On a machine without such support, bigint acts the same as integer (but still takes up eight bytes to both sides of the decimal point. So the number 23.5141 has a precision of 6 and a scale of 4. Integers can be considered to have a scale of zero. 93 Chapter 8. Data Types Both the maximum precision

to the original input. 8.1. Numeric Types Numeric types consist of two-, four-, and eight-byte integers, four- and eight-byte floating-point numbers, and selectable-precision decimals. Table 8-2 lists may not function correctly on all platforms, since it relies on compiler support for eight- byte integers. On a machine without such support, bigint acts the same as integer (but still takes up eight bytes to both sides of the decimal point. So the number 23.5141 has a precision of 6 and a scale of 4. Integers can be considered to have a scale of zero. 93 Chapter 8. Data Types Both the maximum precision

................................. 2878 F.12. dict_int — example full-text search dictionary for integers ............................ 2911 F.13. dict_xsyn — example synonym full-text search dictionary enumerator ............................................... 2933 F.19. intarray — manipulate arrays of integers .................................................... 2935 F.20. isn — data types for international (0 or 1). Hexadecimal digits and the radix prefixes can be in upper or lower case. Note that only integers can have non-decimal forms, not numbers with fractional parts. These are some examples of valid

to the original input. 8.1. Numeric Types Numeric types consist of two-, four-, and eight-byte integers, four- and eight-byte floating-point numbers, and selectable-precision decimals. Table 8-2 lists might not function correctly on all platforms, since it relies on compiler support for eight-byte integers. On a machine without such support, bigint acts the same as integer (but still takes up eight bytes to both sides of the decimal point. So the number 23.5141 has a precision of 6 and a scale of 4. Integers can be considered to have a scale of zero. Both the maximum precision and the maximum scale of

RECURSIVE, a WITH query can refer to its own output. A very simple example is this query to sum the integers from 1 through 100: 99 Chapter 7. Queries WITH RECURSIVE t(n) AS ( VALUES (1) UNION ALL SELECT to the original input. 8.1. Numeric Types Numeric types consist of two-, four-, and eight-byte integers, four- and eight-byte floating-point numbers, and selectable-precision decimals. Table 8-2 lists the bigint type might not function correctly, because it relies on compiler support for eight-byte integers. On such machines, bigint acts the same as integer, but still takes up eight bytes of storage. (We

RECURSIVE, a WITH query can refer to its own output. A very simple example is this query to sum the integers from 1 through 100: 93 Chapter 7. Queries WITH RECURSIVE t(n) AS ( VALUES (1) UNION ALL SELECT to the original input. 8.1. Numeric Types Numeric types consist of two-, four-, and eight-byte integers, four- and eight-byte floating-point num- bers, and selectable-precision decimals. Table 8-2 lists the bigint type might not function correctly, because it relies on compiler support for eight-byte integers. On such machines, bigint acts the same as integer, but still takes up eight bytes of storage. (We

The result of generate_series() is used directly. The ORDER BY clause sorts the column values as integers. 7.2.1.5. LATERAL Subqueries Subqueries appearing in FROM can be preceded by the key word LATERAL RECURSIVE, a WITH query can refer to its own output. A very simple example is this query to sum the integers from 1 through 100: WITH RECURSIVE t(n) AS ( VALUES (1) UNION ALL SELECT n+1 FROM t WHERE to the original input. 8.1. Numeric Types Numeric types consist of two-, four-, and eight-byte integers, four- and eight-byte floating-point num- bers, and selectable-precision decimals. Table 8.2 lists