Re: Problem with createview

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@ikono.com.br
Ikono Sistemas e Automação
http://www.ikono.com.br