Re: [HACKERS] update and select

On Wed, Nov 04, 1998 at 07:25:24AM +0000, Thomas G. Lockhart wrote:
> That is correct, and it is on the ToDo list as something like "allow
> subselects in target expressions" (though I'm not finding it when I
> look).

Would be nice to have, yes.

> However, as you suspect you can rephrase it:
> 
> tgl=> update x set c = j.c from x as j where j.i = 1 and x.i = 0;

True. But unfortunately that won't help me as I was writing an SQL script to
be run on Oracle later on. :-)

Michael
-- 
Dr. Michael Meskes      | Th.-Heuss-Str. 61, D-41812 Erkelenz | Go SF49ers!
Senior-Consultant       | business: Michael.Meskes@mummert.de | Go Rhein Fire!
Mummert+Partner         |  private: Michael.Meskes@usa.net    | Use Debian
Unternehmensberatung AG |           Michael.Meskes@gmx.net    | GNU/Linux!