| From: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jan Wieck <JanWieck(at)Yahoo(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Add Missing From? |
| Date: | 2004-08-11 00:58:02 |
| Message-ID: | 41196F1A.2010503@pse-consulting.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Bruce Momjian wrote:
It's been agreed that the keyword should
> be USING, to avoid anything as confusing as DELETE FROM a FROM b.
FYI,
MSSQL says
DELETE
[FROM]
{tablename}
[FROM {<tablesource> [, ...] ]
[WHERE <condition>]
Note that the first FROM is optional (as in Oracle), we can have
DELETE a FROM b
The USING would be in place of the mandatory FROM in MSSQL. And why use
a different keyword for the same thing in DELETE and UPDATE?
DELETE a FROM b
UPDATE a FROM b
DELETE FROM a USING b
Regards,
Andreas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2004-08-11 02:13:22 | Re: Tablespace issues (comment on ,moving indexes) |
| Previous Message | Cason, Kenny | 2004-08-11 00:21:26 | Looking for C++ bytea example |