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?


Regards,

--
Atenciosamente,

Edson Carlos Ericksson Richter

Reply via email to