274 Setting the Greenplum Database Timezone 275 Setting Greenplum Environment Variables 275 To set up the gpadmin environment for Greenplum Database 276 Next Steps 276 Allowing Client Connections Database 288 Locale Behavior 289 Troubleshooting Locales 290 Character Set Support 290 Setting the Character Set 292 Character Set Conversion Between Server and Client 292 Upgrading to Greenplum 6 294 Developing Functions with PL/Python 470 Data Type Mapping 471 Arrays and Lists 471 Composite Types 472 Set-Returning Functions 473 Running and Preparing SQL Queries 473 plpy.execute 473 plpy.prepare 474

266 Setting the Greenplum Database Timezone 267 Setting Greenplum Environment Variables 267 To set up the gpadmin environment for Greenplum Database 267 Next Steps 268 Allowing Client Connections Database 279 Locale Behavior 280 Troubleshooting Locales 281 Character Set Support 281 Setting the Character Set 283 Character Set Conversion Between Server and Client 283 Upgrading to Greenplum 6 285 Developing Functions with PL/Python 461 Data Type Mapping 461 Arrays and Lists 462 Composite Types 463 Set-Returning Functions 464 Running and Preparing SQL Queries 464 plpy.execute 464 plpy.prepare 465

200 Setting the Greenplum Database Timezone 200 Setting Greenplum Environment Variables 200 To set up the gpadmin environment for Greenplum Database 201 Next Steps 202 Allowing Client Connections Database 213 Locale Behavior 214 Troubleshooting Locales 215 Character Set Support 215 Setting the Character Set 217 Character Set Conversion Between Server and Client 217 Upgrading to Greenplum 6 219 Developing Functions with PL/Python 396 Data Type Mapping 396 Arrays and Lists 397 Composite Types 398 Set-Returning Functions 399 Running and Preparing SQL Queries 399 VMware Greenplum v6.17 Documentation

Tanzu Greenplum v6.20 Documentation VMware, Inc. 11 Setting Greenplum Environment Variables 272 To set up the gpadmin environment for Greenplum Database 272 Next Steps 273 Allowing Client Connections Database 284 Locale Behavior 285 Troubleshooting Locales 286 Character Set Support 286 Setting the Character Set 288 Character Set Conversion Between Server and Client 288 Upgrading to Greenplum 6 290 Developing Functions with PL/Python 464 Data Type Mapping 465 Arrays and Lists 465 Composite Types 466 Set-Returning Functions 467 Running and Preparing SQL Queries 467 plpy.execute 468 VMware Tanzu Greenplum

436 Setting the Greenplum Database Timezone 437 Setting Greenplum Environment Variables 437 To set up the gpadmin environment for Greenplum Database 438 Next Steps 438 Allowing Client Connections Database 455 Locale Behavior 456 Troubleshooting Locales 457 Character Set Support 457 Setting the Character Set 459 Character Set Conversion Between Server and Client 459 Upgrading to Greenplum 6 462 Developing Functions with PL/Python 987 Data Type Mapping 987 Arrays and Lists 987 Composite Types 988 Set-Returning Functions 989 Running and Preparing SQL Queries 990 plpy.execute 990 plpy.prepare 990

Setting Greenplum Environment Variables 422 VMware Tanzu Greenplum 6 Documentation VMware, Inc 17 To set up the gpadmin environment for Greenplum Database 423 Next Steps 423 Allowing Client Connections Database 439 Locale Behavior 441 Troubleshooting Locales 441 Character Set Support 441 Setting the Character Set 443 Character Set Conversion Between Server and Client 444 Upgrading to Greenplum 6 446 resolve duplicate entries. unnest (array[]) set of anyelement unnest( array[‘one’, ‘row’, ‘per’, ‘item’]) Transforms a one dimensional array into rows. Returns a set of anyelement, a polymorphic pseudo-type

419 Setting the Greenplum Database Timezone 419 Setting Greenplum Environment Variables 420 To set up the gpadmin environment for Greenplum Database 420 Next Steps 421 Allowing Client Connections Database 437 Locale Behavior 438 Troubleshooting Locales 439 Character Set Support 439 Setting the Character Set 441 Character Set Conversion Between Server and Client 441 Upgrading to Greenplum 6 443 Developing Functions with PL/Python 951 Data Type Mapping 951 Arrays and Lists 952 Composite Types 953 Set-Returning Functions 954 Running and Preparing SQL Queries 954 plpy.execute 954 plpy.prepare 955

356 Setting the Greenplum Database Timezone 356 Setting Greenplum Environment Variables 357 To set up the gpadmin environment for Greenplum Database 357 Next Steps 358 Allowing Client Connections Database 367 Locale Behavior 369 Troubleshooting Locales 369 Character Set Support 369 Setting the Character Set 371 Character Set Conversion Between Server and Client 371 Upgrading to Greenplum 6 373 resolve duplicate entries. unnest (array[]) set of anyelement unnest( array[‘one’, ‘row’, ‘per’, ‘item’]) Transforms a one dimensional array into rows. Returns a set of anyelement, a polymorphic pseudo-type

430 Setting the Greenplum Database Timezone 430 Setting Greenplum Environment Variables 431 To set up the gpadmin environment for Greenplum Database 431 Next Steps 432 Allowing Client Connections Database 449 Locale Behavior 451 Troubleshooting Locales 451 Character Set Support 451 Setting the Character Set 453 Character Set Conversion Between Server and Client 453 Upgrading to Greenplum 6 456 Functions with PL/Python 1000 Data Type Mapping 1000 Arrays and Lists 1001 Composite Types 1001 Set-Returning Functions 1002 Running and Preparing SQL Queries 1003 plpy.execute 1003 plpy.prepare 1003

411 Setting the Greenplum Database Timezone 412 Setting Greenplum Environment Variables 412 To set up the gpadmin environment for Greenplum Database 413 Next Steps 413 Allowing Client Connections Database 430 Locale Behavior 432 Troubleshooting Locales 432 Character Set Support 432 Setting the Character Set 434 Character Set Conversion Between Server and Client 434 Upgrading to Greenplum 6 437 Developing Functions with PL/Python 969 Data Type Mapping 969 Arrays and Lists 969 Composite Types 970 Set-Returning Functions 971 Running and Preparing SQL Queries 971 plpy.execute 972 plpy.prepare 972