Re: [GENERAL] Array of created types

2005-09-01 Thread Tom Lane
Kelly Burkhart <[EMAIL PROTECTED]> writes: > The create type documentation says that postgres silently creates an > array type for each base type with an underscore prepended to the base > name. "Base type" in this context specifically means "not composite type". We may support that someday, but i

[GENERAL] Array of created types

2005-09-01 Thread Kelly Burkhart
Should something similar to the following be possible in PG 8.0.3? create type foo_t as ( c1 int, c2 int ); create table tab ( name varchar not null, foos foo_t[] ); The response I get is: ERROR: type "foo_t[]" does not exist The create type documentation says that postgres silently create