Re: Are these supported??

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Greg Stark <stark(at)mit(dot)edu>
Cc: Vince Vielhaber <vev(at)chives(dot)michvhf(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Are these supported??
Date: 2016-08-17 15:22:46
Message-ID: CA+TgmoZfCFrKDW6UbxAwReSMNQd=7Kg7Wi31XP3KxUiuSM2X3g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Aug 17, 2016 at 10:38 AM, Greg Stark <stark(at)mit(dot)edu> wrote:
> You can't have joins in a DELETE -- which table would it actually
> delete from? You can use a subselect to do look up information from
> other tables in your delete though.

We've supported having joins in a DELETE since PostgreSQL 8.1.

https://www.postgresql.org/docs/8.1/static/sql-delete.html

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2016-08-17 15:27:56 Re: PATCH: Exclude additional directories in pg_basebackup
Previous Message Ryan Murphy 2016-08-17 15:21:03 Re: Patch: initdb: "'" for QUOTE_PATH (non-windows)