Partitioning Strategy 349 Choosing the Partitioning Syntax 350 Creating a Partitioned Table 351 Creating Partitioned Tables with the Modern Syntax 352 Defining a Date-Range Partitioned Table 352 Defining Classic Syntax Sub-Partition Template 358 Constructing a pg_partitions-Equivalent Query 358 About Partition Pruning 358 Partition Maintenance 360 Partition Maintenance with the Modern Syntax 360 Adding Changed With Classic Syntax? 367 What Has Changed? 367 Additional Considerations 370 Examples Using the Classic Partitioning Syntax 370 Creating Partitioned Tables with the Classic Syntax 370 Creating a

Characters in JSON Data 912 Mapping JSON Data Types to Greenplum Data Types 913 JSON Input and Output Syntax 914 Designing JSON documents 914 jsonb Containment and Existence 915 jsonb Indexing 917 GIN Indexes Guide 1055 Greenplum Database Reference Guide 0 SQL Commands 1055 SQL Commands 0 SQL Syntax Summary 1060 SQL Syntax Summary 0 ABORT 1060 ALTER AGGREGATE 1060 ALTER COLLATION 1060 ALTER CONVERSION 1060 Cluster Management 32012, 31894 : Resolves an issue where gpcheckcat returned the error invalid input syntax for integer during the orphaned_toast_tables test because the command did not correctly handle a

Characters in JSON Data 903 Mapping JSON Data Types to Greenplum Data Types 904 JSON Input and Output Syntax 905 Designing JSON documents 905 jsonb Containment and Existence 906 jsonb Indexing 908 GIN Indexes Guide 1046 Greenplum Database Reference Guide 0 SQL Commands 1046 SQL Commands 0 SQL Syntax Summary 1051 SQL Syntax Summary 0 ABORT 1051 ALTER AGGREGATE 1051 ALTER COLLATION 1051 ALTER CONVERSION 1051 Documentation VMware, Inc. 171 Because Greenplum Database does not enforce referential integrity syntax (foreign key constraints), the TRUNCATE command was updated so that it truncates a table referenced

Characters in JSON Data 823 Mapping JSON Data Types to Greenplum Data Types 824 JSON Input and Output Syntax 825 Designing JSON documents 826 jsonb Containment and Existence 826 jsonb Indexing 828 GIN Indexes Implementing Block Mirroring 1296 Greenplum Database Reference Guide 1298 SQL Commands 1298 SQL Syntax Summary 1307 ABORT 1308 ALTER AGGREGATE 1308 ALTER COLLATION 1308 ALTER CONVERSION 1308 ALTER 2156 See Also 2157 pgbouncer-admin 2157 Synopsis 2157 Description 2157 Options 2157 Command Syntax 2157 Administration Commands 2158 SHOW Command 2159 CLIENTS 2160 CONFIG 2160 DATABASES 2161

Advanced Aggregate Functions 784 Table 5. Advanced Aggregate Functions Function Return Type Full Syntax Description MEDIAN (expr) timestamp, timestamptz, interval, float MEDIAN (expression) Example: SELECT Characters in JSON Data 786 Mapping JSON Data Types to Greenplum Data Types 787 JSON Input and Output Syntax 787 Designing JSON documents 788 jsonb Containment and Existence 789 jsonb Indexing 790 GIN Indexes Implementing Block Mirroring 1239 Greenplum Database Reference Guide 1241 SQL Commands 1241 SQL Syntax Summary 1250 ABORT 1250 ALTER AGGREGATE 1251 ALTER COLLATION 1251 ALTER CONVERSION 1251 ALTER

Characters in JSON Data 794 Mapping JSON Data Types to Greenplum Data Types 795 JSON Input and Output Syntax 796 Designing JSON documents 797 jsonb Containment and Existence 797 jsonb Indexing 799 GIN Indexes Implementing Block Mirroring 1264 Greenplum Database Reference Guide 1266 SQL Commands 1266 SQL Syntax Summary 1275 ABORT 1276 ALTER AGGREGATE 1276 ALTER COLLATION 1276 ALTER CONVERSION 1276 ALTER 2112 See Also 2114 pgbouncer-admin 2114 Synopsis 2114 Description 2114 Options 2114 Command Syntax 2114 Administration Commands 2115 SHOW Command 2116 CLIENTS 2117 CONFIG 2117 DATABASES 2117

Advanced Aggregate Functions 677 Table 5. Advanced Aggregate Functions Function Return Type Full Syntax Description MEDIAN (expr) timestamp, timestamptz, interval, float MEDIAN (expression) Example: SELECT Characters in JSON Data 679 Mapping JSON Data Types to Greenplum Data Types 679 JSON Input and Output Syntax 680 Designing JSON documents 681 jsonb Containment and Existence 681 jsonb Indexing 683 GIN Indexes Implementing Block Mirroring 1084 Greenplum Database Reference Guide 1086 SQL Commands 1086 SQL Syntax Summary 1094 ABORT 1094 ALTER AGGREGATE 1095 ALTER COLLATION 1095 ALTER CONVERSION 1095 ALTER

Characters in JSON Data 814 Mapping JSON Data Types to Greenplum Data Types 815 JSON Input and Output Syntax 816 Designing JSON documents 816 jsonb Containment and Existence 817 jsonb Indexing 819 GIN Indexes Implementing Block Mirroring 1279 Greenplum Database Reference Guide 1281 SQL Commands 1281 SQL Syntax Summary 1290 ABORT 1290 ALTER AGGREGATE 1291 ALTER COLLATION 1291 ALTER CONVERSION 1291 ALTER 2106 See Also 2107 pgbouncer-admin 2107 Synopsis 2107 Description 2107 Options 2108 Command Syntax 2108 Administration Commands 2108 SHOW Command 2109 CLIENTS 2110 VMware Greenplum 6 Documentation

Characters in JSON Data 835 Mapping JSON Data Types to Greenplum Data Types 836 JSON Input and Output Syntax 837 Designing JSON documents 837 jsonb Containment and Existence 838 jsonb Indexing 840 GIN Indexes Guide 982 Greenplum Database Reference Guide 0 SQL Commands 982 SQL Commands 0 SQL Syntax Summary 987 SQL Syntax Summary 0 ABORT 987 ALTER AGGREGATE 987 ALTER COLLATION 987 ALTER CONVERSION 987 configuration parameter gp_ignore_error_table (deprecated since 6.0). To avoid a Greenplum Database syntax error, set the value of this parameter to true when you run applications that execute CREATE EXTERNAL

Characters in JSON Data 785 Mapping JSON Data Types to Greenplum Data Types 786 JSON Input and Output Syntax 786 Designing JSON documents 787 jsonb Containment and Existence 788 jsonb Indexing 789 GIN Indexes Implementing Block Mirroring 1234 Greenplum Database Reference Guide 1236 SQL Commands 1236 SQL Syntax Summary 1245 ABORT 1246 ALTER AGGREGATE 1246 ALTER COLLATION 1246 ALTER CONVERSION 1246 ALTER 2030 See Also 2031 pgbouncer-admin 2031 Synopsis 2032 Description 2032 Options 2032 Command Syntax 2032 Administration Commands 2032 SHOW Command 2034 CLIENTS 2034 CONFIG 2035 DATABASES 2035