Neil Conway <[EMAIL PROTECTED]> writes: > On a related note, UPDATE uses the FROM keyword to denote the list of > relations to join with, whereas DELETE uses USING. Should we make USING > an alias for FROM in UPDATE and if so, should we deprecate FROM? This > would be more consistent, which I suppose is a good thing.
Of course, the entire reason this didn't happen years ago is that we couldn't agree on what keyword to use... you sure you want to reopen that discussion? I don't think changing UPDATE is a good idea. It's consistent with SELECT and people are used to it. You could argue that something like DELETE FROM target [ { USING | FROM } othertables ] ... is the best compromise. Those who like consistency can write FROM, those who don't like "FROM a FROM b" can write something else. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq