DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:cc:subject:references:mime-version
	:content-type:content-disposition:in-reply-to:user-agent;
	b=pkiewKioyMU9bW9MZ4LnC1HwyKVhMD0yQ9jCUHHyvTFpxCD61NPIuztDUo2vZ2CXNt
	qyyHaphamC1xjfhgseqXRp1giQTnSQNx8U7+pa/B8BGKv5+4TENYfYyCDnjHSlhgi0P8
	dydM67dQvzxstdJNWzIWVInP9i0I7EMmCzJWM=
Message-ID: <4c4ad2d6.0bb48c0a.7970.5678@mx.google.com>
Date: Sat, 24 Jul 2010 05:47:24 -0600
From: Joshua Tolley <eggyknap@gmail.com>
To: Andreas <maps.on@gmx.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: howto  delete  using a join ?
References: <4C4A66A5.9070609@gmx.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="bCsyhTFzCvuiizWE"
Content-Disposition: inline
In-Reply-To: <4C4A66A5.9070609@gmx.net>
User-Agent: Mutt/1.5.18 (2008-05-17)


--bCsyhTFzCvuiizWE
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Sat, Jul 24, 2010 at 06:05:57AM +0200, Andreas wrote:
>  Hi,
>
> is there a way to delete from a table using information from another =20
> table to decide if a row should be dropped?

Yes. See DELETE ... USING

http://www.postgresql.org/docs/8.4/interactive/sql-delete.html

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com

--bCsyhTFzCvuiizWE
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkxK0swACgkQRiRfCGf1UMPoyQCeL+ov/imte/+lmao5koysUsiu
gWQAn2yzfxAcX3wh88M3oJZL9HDvl50R
=tSvh
-----END PGP SIGNATURE-----

--bCsyhTFzCvuiizWE--