1

Temat: problem z array'em w composite type

CREATE TYPE t_01 AS (
   id BIGINT,
   name VARCHAR,
   value VARCHAR
);

2

Odp: problem z array'em w composite type

Jaki postgres?, bo z tego co pamietam to tabele typow zlozonych sa wspierane dopiero od 8.3

3

Odp: problem z array'em w composite type

PostgreSQL 8.2.1

ja gdzies przeczytalem ze od 8.x

dobra zobacze w 8.3

dzieki

4

Odp: problem z array'em w composite type

cytat z dokumentacji (postgresql.org)
8.2.9 (i wcześniejszy)
"PostgreSQL allows columns of a table to be defined as variable-length multidimensional arrays. Arrays of any built-in or user-defined base type can be created. (Arrays of composite types or domains are not yet supported, however.)"
8.3.3 (i inne z gałęzi 8.3)
"PostgreSQL allows columns of a table to be defined as variable-length multidimensional arrays. Arrays of any built-in or user-defined base type, enum type, or composite type can be created. Arrays of domains are not yet supported."