From: | Diogo Biazus <diogo(at)ikono(dot)com(dot)br> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Problem with createview |
Date: | 2002-10-04 18:39:06 |
Message-ID: | 3D9DE04A.9010609@ikono.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Tom Lane wrote:
>If codagendabusca is the only duplicate-named field in the tables,
>you could change
> left join buscas on agendasbusca.codagendabusca = buscas.codagendabusca
>to
> natural left join buscas using (codagendabusca)
>
>
That's another problem, there other fields, and some of then aren't the
same thing
>"NATURAL" produces an automatic JOIN ON clause that equates each
>similarly-named pair of fields, and it also removes one of each such
>pair of columns from the result.
>
>
Good to know this kind of thing.
>Of course, you have to be careful not to create unintended column
>name matches, so I'm not sure this is really a whole lot better
>from a maintenance point of view.
>
>
>
You're right.
I think it's better to define which fields I'm gonna use.
Thanks for the help.
--
Diogo de Oliveira Biazus
diogo(at)ikono(dot)com(dot)br
Ikono Sistemas e Automação
http://www.ikono.com.br
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-10-04 18:47:47 | Re: Pinning a table into memory |
Previous Message | Tom Lane | 2002-10-04 18:34:03 | Re: DTOI4 integer out of range |