Re: [SQL] Trouble with composite types

2004-02-29 Thread Joe Conway
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,

[SQL] Trouble with composite types

2004-02-29 Thread Yasir Malik
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),