Hello
I am using postgres r8.1 and i make 2 Composite Types
as:
CREATE TYPE regiao AS (pais_nome
varchar(150), estado_nome
varchar(150), estado_sigla
varchar(4), cidade_nome varchar(150));ALTER TYPE
regiao OWNER TO postgres;==
and
CREATE TYPE telcontato AS
(telefone1
Jose [EMAIL PROTECTED] writes:
If I try use
select unidade_regiao.(estado_sigla) from unidades
No, you should do
select (unidade_regiao).estado_sigla from unidades
regards, tom lane
---(end of broadcast)---
TIP 7: You
This is *not* a good practice to handle elements of a composite data
type seperately because they all build it up together and without one
of it, the data type is meaningless.
Secondly, If you are going to base our application on this principle,
you better rethink your design.
--Imad
