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, city text, state char(2), zip_code char(5) ); 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, how do I add a member function to a type? Thanks, Yasir ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend