Re: [HACKERS] Playing with UPDATEs ...

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Playing with UPDATEs ...
Date: 2000-01-21 15:12:48
Message-ID: 38887770.B2CB2E2F@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)alumni(dot)caltech(dot)edu
South Pasadena, California

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 2000-01-21 15:16:39 Re: [HACKERS] Building Documentation under Debian
Previous Message Bruce Momjian 2000-01-21 15:11:26 Re: Status on 7.0