Re: Efficient DELETE Strategies

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Manfred Koizar <mkoi-pg(at)aon(dot)at>
Cc: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>, pgsql-sql(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Efficient DELETE Strategies
Date: 2002-06-10 22:41:37
Message-ID: 200206101541.37049.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql


Tom,

> >> If so, what's their syntax?
>
> > MSSQL seems to guess what the user wants.
>
> Gack. Nothing like treating mindless syntax variations as a "feature"
> list...

I vote that we stick to a strick SQL92 interpretation, here.
1) It's standard
2) Strict syntax on DELETE statements is better.

Personally, I would *not* want the database to "guess what I want" in a delete
statement; it might guess wrong and there go my records ...

Heck, one of the things I need to research how to turn off in PostgreSQL is
the "Add missing FROM-clause" feature, which has tripped me up many times.

--
-Josh Berkus

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2002-06-10 22:43:02 Re: Will postgress handle too big tables?
Previous Message Josh Berkus 2002-06-10 22:36:42 Re: Default privileges for new databases (was Re: Can't import large objects in most recent cvs)

Browse pgsql-sql by date

  From Date Subject
Next Message Dann Corbit 2002-06-10 23:08:03 Re: [HACKERS] Efficient DELETE Strategies
Previous Message Tom Lane 2002-06-10 21:07:56 Re: Efficient DELETE Strategies