Re: Composite Types

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jose" <jvfingercw(at)wiseup(dot)com(dot)br>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Composite Types
Date: 2006-11-06 19:18:45
Message-ID: 28808.1162840725@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Jose" <jvfingercw(at)wiseup(dot)com(dot)br> 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Ezequias Rodrigues da Rocha 2006-11-06 19:18:52 Groups and Roles and Users
Previous Message imad 2006-11-06 19:07:10 Re: Nested select