
Just curious, but shouldn't something like this be possible?  Or is my
syntax just off?

update dict d, dictionary m  
   set d.word = m.word_val      
 where d.word = m.word;

I want to go through one table and replace all occurances of every word in
the second table with a numeric value ...

I've tried it as:

update dict, dictionary
   set dict.word = dictionary.word_val
 where dict.word = dictionary.word;

and that doesn't work either ...

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 


Fri, 21 Jan 2000 09:46:03 -0400 (AST)
The Hermit Hacker <scrappy@hub.org>
Playing with UPDATEs ...
update dict
 set word = m.word_val
 from dictionary m
 where dict.word = m.word;

> I want to go through one table and replace all occurances of every word in
> the second table with a numeric value ...

                  - Thomas

-- 
Thomas Lockhart				lockhart@alumni.caltech.edu
South Pasadena, California

Fri, 21 Jan 2000 15:12:48 +0000
Thomas Lockhart <lockhart@alumni.caltech.edu>
Re: [HACKERS] Playing with UPDATEs ...