hi,everyone,first thank you help me relove the problem about complex type.
now i have other two question about complex type field.
firstly, i want to know if the complex type data can be dump into the database
by command 'copy'?
secondly, i try it but failure. The following is detail about my oper
hi all, i want to know how to insert values into the field which is a complex
type. In fact it is a complex type which also include a complex type. The
following is its definition:
create TYPE lifetime as( strattime date, endtime date);
create TYPE attributetype as( ID numeric, address character(
hi, now i meet a question about the complex field. Firstly i create a complex
type (the sql is "CREATE TYPE test11 as (area numeric, address character
varying(30))")and then i create a table ,set a field named "tt" whose type is
test11. Now i want insert the data which select from another talble
