players.ast` Array(Array(Int8)), `teams.players.blk` Array(Array(Int8)), `teams.players.drb` Array(Array(Int8)), `teams.players.fg` Array(Array(Int8)), `teams.players.fg3` Array(Array(Int8)), `teams.players.fg3_pct` Array(Array(String)), `teams.players.fg3a` Array(Array(Int8)), `teams.players.fg_pct` Array(Array(String)), `teams.players.fga` Array(Array(Int8)), `teams.players.ft` Array(Array(Int8)), `teams.players.ft_pct` Array(Array(String)) Array(Array(String)), `teams.players.fta` Array(Array(Int8)), `teams.players.mp` Array(Array(String)), `teams.players.orb` Array(Array(Int8)), `teams.players.pf` Array(Array(Int8)), `teams.players.player` Array(Array(String))

players.ast` Array(Array(Int8)), `teams.players.blk` Array(Array(Int8)), `teams.players.drb` Array(Array(Int8)), `teams.players.fg` Array(Array(Int8)), `teams.players.fg3` Array(Array(Int8)), `teams.players.fg3_pct` Array(Array(String)), `teams.players.fg3a` Array(Array(Int8)), `teams.players.fg_pct` Array(Array(String)), `teams.players.fga` Array(Array(Int8)), `teams.players.ft` Array(Array(Int8)), `teams.players.ft_pct` Array(Array(String)) Array(Array(String)), `teams.players.fta` Array(Array(Int8)), `teams.players.mp` Array(Array(String)), `teams.players.orb` Array(Array(Int8)), `teams.players.pf` Array(Array(Int8)), `teams.players.player` Array(Array(String))

available, but they are not listed here. Table 8-1. Data Types Name Aliases Description bigint int8 signed eight-byte integer bigserial serial8 autoincrementing eight-byte integer bit [ (n) ] fixed-length specifies the integer types integer (or int), smallint, and bigint. The type names int2, int4, and int8 are extensions, which are shared with various other SQL database systems. 8.1.2. Arbitrary Precision ~ operators should be pre- ferred. We can help it out with an explicit cast: SELECT ~ CAST(’20’ AS int8) AS "negation"; negation ---------- -21 (1 row) 10.3. Functions The specific function to be used

available, but they are not listed here. Table 8-1. Data Types Name Aliases Description bigint int8 signed eight-byte integer bigserial serial8 autoincrementing eight-byte integer bit [ (n) ] fixed-length specifies the integer types integer (or int), smallint, and bigint. The type names int2, int4, and int8 are extensions, which are shared with various other SQL database systems. 8.1.2. Arbitrary Precision possible ~ operators should be preferred. We can help it out with an explicit cast: SELECT ~ CAST(’20’ AS int8) AS "negation"; negation ---------- -21 (1 row) 10.3. Functions The specific function to be used

types are available, but are not listed here. Table 8.1. Data Types Name Aliases Description bigint int8 signed eight-byte integer bigserial serial8 autoincrementing eight-byte integer bit [ (n) ] fixed-length specifies the integer types integer (or int), smallint, and bigint. The type names int2, int4, and int8 are extensions, which are also used by some other SQL database systems. 8.1.2. Arbitrary Precision operators should be pre- ferred. We can help it out with an explicit cast: SELECT ~ CAST('20' AS int8) AS "negation"; negation ---------- -21 (1 row) Example 10.4. Array Inclusion Operator Type

types are available, but are not listed here. Table 8.1. Data Types Name Aliases Description bigint int8 signed eight-byte integer bigserial serial8 autoincrementing eight-byte integer bit [ (n) ] fixed-length specifies the integer types integer (or int), smallint, and bigint. The type names int2, int4, and int8 are extensions, which are also used by some other SQL database systems. 8.1.2. Arbitrary Precision ~ operators should be preferred. We can help it out with an explicit cast: SELECT ~ CAST('20' AS int8) AS "negation"; negation ---------- -21 (1 row) Example 10.4. Array Inclusion Operator Type

types are available, but are not listed here. Table 8-1. Data Types Name Aliases Description bigint int8 signed eight-byte integer bigserial serial8 autoincrementing eight-byte integer bit [ (n) ] fixed-length specifies the integer types integer (or int), smallint, and bigint. The type names int2, int4, and int8 are extensions, which are also used by some other SQL database systems. 8.1.2. Arbitrary Precision possible ~ operators should be preferred. We can help it out with an explicit cast: SELECT ~ CAST(’20’ AS int8) AS "negation"; negation ---------- -21 (1 row) 10.3. Functions The specific function that is referenced

types are available, but are not listed here. Table 8-1. Data Types Name Aliases Description bigint int8 signed eight-byte integer bigserial serial8 autoincrementing eight-byte integer bit [ (n) ] fixed-length specifies the integer types integer (or int), smallint, and bigint. The type names int2, int4, and int8 are extensions, which are also used by some other SQL database systems. 8.1.2. Arbitrary Precision ~ operators should be pre- ferred. We can help it out with an explicit cast: SELECT ~ CAST(’20’ AS int8) AS "negation"; negation ---------- -21 (1 row) 10.3. Functions The specific function that is referenced

types are available, but are not listed here. Table 8.1. Data Types Name Aliases Description bigint int8 signed eight-byte integer bigserial serial8 autoincrementing eight-byte integer bit [ (n) ] fixed-length specifies the integer types integer (or int), smallint, and bigint. The type names int2, int4, and int8 are extensions, which are also used by some other SQL database systems. 8.1.2. Arbitrary Precision operators should be pre- ferred. We can help it out with an explicit cast: SELECT ~ CAST('20' AS int8) AS "negation"; negation ---------- -21 (1 row) Example 10.4. Array Inclusion Operator Type

types are available, but are not listed here. Table 8.1. Data Types Name Aliases Description bigint int8 signed eight-byte integer bigserial serial8 autoincrementing eight-byte integer bit [ (n) ] fixed-length specifies the integer types integer (or int), smallint, and bigint. The type names int2, int4, and int8 are extensions, which are also used by some other SQL database systems. 8.1.2. Arbitrary Precision ~ operators should be preferred. We can help it out with an explicit cast: SELECT ~ CAST('20' AS int8) AS "negation"; negation ---------- -21 (1 row) Example 10.4. Array Inclusion Operator Type