| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Kernel <jucabapa(at)gmail(dot)com> |
| Cc: | Freddy Martinez <freddy311082(at)gmail(dot)com>, PostgreSQL Lista Castellano <pgsql-es-ayuda(at)postgresql(dot)org> |
| Subject: | Re: Consulta recursiva |
| Date: | 2016-10-21 19:51:50 |
| Message-ID: | 20161021195150.4wztx7yypzoxqhme@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
Kernel escribió:
> De manera intencionada he generado un bucle, ¿Hay alguna manera de prevenir
> esto?,¿hay alguna manera de limitar el numero de bucles?
Sí. https://www.postgresql.org/docs/9.5/static/queries-with.html
Desde "When working with recursive queries it is important to be sure
that the recursive part of the query will eventually return no tuples,
or else the query will loop indefinitely."
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
-
Enviado a la lista de correo pgsql-es-ayuda (pgsql-es-ayuda(at)postgresql(dot)org)
Para cambiar tu suscripción:
http://www.postgresql.org/mailpref/pgsql-es-ayuda
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ivan Perales M. | 2016-10-21 21:07:25 | Convertir de integer a text |
| Previous Message | Adrian Klaver | 2016-10-21 17:31:35 | Re: [psycopg] OT? plpython2u |