Re: [HACKERS] Efficient DELETE Strategies

From: Barry Lind <barry(at)xythos(dot)com>
To: Hannu Krosing <hannu(at)tm(dot)ee>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Christoph Haller <ch(at)rodos(dot)fzk(dot)de>, pgsql-sql(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Efficient DELETE Strategies
Date: 2002-06-11 00:25:19
Message-ID: 3D05436F.5040008@xythos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

This

Hannu Krosing wrote:
> DELETE relation_expr FROM relation_expr [ , table_ref [ , ... ] ]
> [ WHERE bool_expr ]

This in some ways is similar to Oracle where the FROM is optional in a
DELETE (ie. DELETE foo WHERE ...). By omitting the first FROM, the
syntax ends up mirroring the UPDATE case:

DELETE foo FROM bar WHERE ...

UPDATE foo FROM bar WHERE ...

However I think the syntax should also support the first FROM as being
optional (even though it looks confusing):

DELETE FROM foo FROM bar WHERE ...

thanks,
--Barry

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David Ford 2002-06-11 01:16:23 Re: PostGres Doubt
Previous Message Dann Corbit 2002-06-10 23:08:03 Re: [HACKERS] Efficient DELETE Strategies

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2002-06-11 02:53:00 Re: [HACKERS] Efficient DELETE Strategies
Previous Message Dann Corbit 2002-06-10 23:08:03 Re: [HACKERS] Efficient DELETE Strategies