GreenPlum version is PostgreSQL 8.2.15 (GreenPlum Database 4.3.11.3 build 1), a new compound type person (name varchar (50), age int),

Company now needs new tables, table field is person arrays, the type of employees the following written all error:

1. Create table company (employees person []);

- an ERROR: (Err) ERROR: type "person []" does not exist

2. The create table company (employees person array [100]).


How do I create an array of person type of column in the new list?

CodePudding user response:

What is your business scenario, it is necessary to use such data structures? To describe your scene, should need not so duplicate data types,
Divided into two packages, through outside the main health management can't?