Olá, Em 15 de julho de 2010 09:25, Ruy Carlos Nunes de Souza < [email protected]> escreveu:
> Bom dia, > > Estou com problema de utilização da cláusula WITH com SELECT. > Segundo manual poderia utiliza-lo da seguinte forma: > Qual versão do PG? Este recurso está disponível apenas da versão 8.4. > > * > > 7.8. > WITH Queries* > > WITH > provides a way to write subqueries for use in a larger SELECT query. The > subqueries can be > > thought of as defining temporary tables that exist just for this query. One > use of this feature is to break > > down complicated queries into simpler parts. An example is: > > WITH regional_sales AS ( > > SELECT region, SUM(amount) AS total_sales > > FROM orders > > GROUP BY region > > ), top_regions AS ( > > SELECT region > > FROM regional_sales > > WHERE total_sales > > (SELECT SUM(total_sales)/10 FROM regional_sales) > > ) > > SELECT region, > > product, > > SUM(quantity) AS product_units, > > SUM(amount) AS product_sales > > FROM orders > > WHERE region IN (SELECT region FROM top_regions) > > GROUP BY region, product; > > Só que quando tento utilizar no pgAdmin um exemplo parecido, me é > apresentado o seguinte erro: > > ERROR: syntax error at or near "with" > SQL state: 42601 > > Alguém poderia ajudar? > > > > > > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > > []s -- JotaComm http://jotacomm.wordpress.com
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
