Re: Divergences in view source code - both servers 9.3.5

Edson Richter <edsonrichter(at)hotmail(dot)com> writes:
> I do have two servers running 9.3.5.
> One server is CentOS 6.5 x64 with all updates.
> The other server is Ubuntu 14.04-1 x64 with all updates.
> Both run PostgreSQL 9.3.5 x64 - one installed using YUM, other with APT.

> When I compare source code of the same view, I get the following
> differences:

> *_On "Ubuntu" server:_*

> ( ( ( ( select
> e.id,
> e.nome as "empresa",
> '1. nfe'::text as "tipo",
> ( select sum(arquivosimportados.contasucesso) as sum

> _*On CentOS server:*_

> select
> e.id,
> e.nome as "empresa",
> '1. nfe'::text as "tipo",
> ( select sum(arquivosimportados.contasucesso) as sum

> Why does the same CREATE VIEW statement result in different source codes
> in the server side?

You've not shown us the whole output, but is this the first select
in a UNION (or INTERSECT or EXCEPT) nest? If so, I'll bet a nickel
that that Ubuntu server is not actually running 9.3.5; try
"select version()" to confirm. The CentOS server is returning what
I'd expect after commit 0652d77fb067137be22dc3e42aa60bffa26726ac.

regards, tom lane