Re: Add Missing From?

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: josh(at)agliodbs(dot)com
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jan Wieck <JanWieck(at)Yahoo(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 10:28:17
Message-ID: 4119F4C1.40302@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Josh Berkus wrote:
> Andreas,
>
>
>>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?
>
>
> Um, because for us the 1st FROM isn't optional (per SQL spec)?
>

Seems that many RDBMS regard that FROM as a noise word. Making it
optional would probably enhance portability, I can't see drawbacks.

Regards,
Andreas

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Harald Fuchs 2004-08-11 11:50:14 Re: Add Missing From?
Previous Message Andreas Pflug 2004-08-11 10:15:14 Re: 8.0 Release notes