X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 89600534B4 for ; Wed, 6 Apr 2005 17:45:57 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 20625-01 for ; Wed, 6 Apr 2005 16:45:56 +0000 (GMT) Received: from uead1.campusvirtual.br (unknown [200.222.48.40]) by svr1.postgresql.org (Postfix) with ESMTP id 3F3F753245 for ; Wed, 6 Apr 2005 17:45:52 +0100 (BST) Received: from silvio (unknown [10.40.0.27]) by uead1.campusvirtual.br (Postfix) with SMTP id 56B65192736 for ; Wed, 6 Apr 2005 16:27:57 +0000 (UTC) Message-ID: <006701c53ac8$014b27e0$1b00280a@ugf.br> From: =?iso-8859-1?Q?Ricardo_Valen=E7a_de_Assis?= To: Subject: delete to slow Date: Wed, 6 Apr 2005 13:45:13 -0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0064_01C53AAE.DBE585E0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Campus_Virtual-UGF-MailScanner-Information: Please contact the ISP for more information X-Campus_Virtual-UGF-MailScanner: Found to be clean X-MailScanner-From: valenca@campusvirtual.br X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.525 tagged_above=0 required=5 tests=AWL, HTML_MESSAGE, RCVD_IN_XBL, UPPERCASE_25_50 X-Spam-Level: * X-Archive-Number: 200504/76 X-Sequence-Number: 17089 This is a multi-part message in MIME format. ------=_NextPart_000_0064_01C53AAE.DBE585E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello Everybody! I=B4m trying to use delete to remove data from one table based on = another. The query is this: DELETE FROM table1 WHERE column1 IN (SELECT column2 FROM table2); but my table is big, so it takes a lot o time... Is there a way to use DELETE with INNER JOIN in PostGreSQL? Thanks! Att. Ricardo Valen=E7a UEAD - UGF ------=_NextPart_000_0064_01C53AAE.DBE585E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello Everybody!
 
    I=B4m trying to use = delete to=20 remove data from one table based on another. The query is = this:
 
    DELETE FROM table1 = WHERE column1=20 IN (SELECT column2 FROM table2);
 
    but my table is big, = so it takes=20 a lot o time...
    Is there a way to = use DELETE=20 with INNER JOIN in PostGreSQL?
 
Thanks!
 
Att.
Ricardo Valen=E7a
UEAD -=20 UGF
------=_NextPart_000_0064_01C53AAE.DBE585E0--