Yasir Malik wrote:
[attempts to use a composite type as a field data type of another
composite type]
When I enter that into the command prompt, I the following message:
ERROR: Attribute "street" has composite type street_type
Why is it giving me error message for something I know is true? Also,
Hello,
I don't know why this message is not going through!
I have the following types:
create type street_type as
(
street_number smallint,
street_name text,
apt_number smallint
);
create type address_type as
(
street street_type,
citytext,
state char(2),