Horton
Menu

Re: [QUESTIONS] How fully will subselects be implemented?

Bruce Momjian <maillist@candle.pha.pa.us>

View thread
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: vadim@sable.krasnoyarsk.su (Vadim B. Mikheev)
Cc: herouth@oumail.openu.ac.il, hackers@postgreSQL.org (PostgreSQL-development)
Date: 1998-02-25T14:29:03Z
Lists: pgsql-hackers 
> 
> Herouth Maoz wrote:
> > 
> > I'm developing a new app, and I constantly run into the need of updating
> > things by data in related columns.
> > 
> > Since UPDATE doesn't syntatctically support joins, this means that
> > subselects in UPDATE are a real must.

OK, now I see he only wants the subquery in the where clause.  That
clearly does work.

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)