Skip site navigation (1) Skip section navigation (2)

Borrar

From: "Miguel Angel" <mvillagomez(at)sayab(dot)com(dot)mx>
To: <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Borrar
Date: 2006-02-24 20:37:38
Message-ID: 20060224203825.D67FB9DC9F1@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-es-ayuda
Por que razón el postgres no me permite realizar este borrado?

 

Me aparece error en el Select pero no se porque y aun cuando le ponga un
alias, tampoco funciona.

 

DELETE FROM SELECT c1.add_id FROM con_addr c0 INNER JOIN addr c1 ON
(c0.addr_id=c1.addr_id) WHERE con_id=3

 

DELETE FROM (SELECT c1.add_id FROM con_addr c0 INNER JOIN addr c1 ON
(c0.addr_id=c1.addr_id) WHERE con_id=3) As lista;

Responses

  • Re: Borrar at 2006-02-24 22:49:49 from Alvaro Herrera

pgsql-es-ayuda by date

Next:From: Dimas AyalaDate: 2006-02-24 20:55:41
Subject: Re: Uso de memoria por conexion.
Previous:From: Mario GonzalezDate: 2006-02-24 20:19:22
Subject: Re: Uso de memoria por conexion.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group