alguma novidade do motor nao tive mais noticias suas
2009/12/7 Tarcísio Sassara <[email protected]> > 2009/12/7 Bruno Sales <[email protected]>: > > eu fuçando aqui ficou assim: > > > > > > > > SELECT meso.the_geom, meso.gid, meso.nome, estabest2007 + > > estabest2007_9_anos as estabest2007, estabfed2007 + > > estabfed2007_9_anos as estabfed2007, estabmun2007 + > > estabmun2007_9_anos as estabmun2007, estabpriv2007 + > > estabpriv2007_9_anos as estabpriv2007 > > FROM ( SELECT soc_estab_nfm_2007.mesoregiao, > > sum(soc_estab_nfm_2007.estab_fund_fed) AS estabfed2007, > > sum(soc_estab_nfm_2007.estab_fund_est) AS estabest2007, > > sum(soc_estab_nfm_2007.estab_fund_mun) AS estabmun2007, > > sum(soc_estab_nfm_2007.estab_fund_priv) AS estabpriv2007 > > FROM social.soc_estab_nfm_2007 > > GROUP BY soc_estab_nfm_2007.mesoregiao) estab2007, ( SELECT > > soc_estab_nfm_2007_9_anos.mesoregiao, > > sum(soc_estab_nfm_2007_9_anos.estab_fund_fed) AS estabfed2007_9_anos, > > sum(soc_estab_nfm_2007_9_anos.estab_fund_est) AS estabest2007_9_anos, > > sum(soc_estab_nfm_2007_9_anos.estab_fund_mun) AS estabmun2007_9_anos, > > sum(soc_estab_nfm_2007_9_anos.estab_fund_priv) AS estabpriv2007_9_anos > > FROM social.soc_estab_nfm_2007_9_anos > > GROUP BY soc_estab_nfm_2007_9_anos.mesoregiao) > > estab2007_9_anos, ( SELECT mesoregioes.the_geom, mesoregioes.gid, > > mesoregioes.nome > > FROM mesoregioes) meso > > WHERE estab2007.mesoregiao::text = estab2007_9_anos.mesoregiao::text > > AND estab2007.mesoregiao::text = meso.nome::text AND > > estab2007_9_anos.mesoregiao = meso.nome::text > > > > > > Você está usando a versão 8.3? > Na versão 8.4 é possível simplicar com a clausula WITH: > http://www.postgresql.org/docs/8.4/interactive/queries-with.html > > > -- > Tarcisio F. Sassara > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
