trouble updating

From: "Tim Joyce" <tim(at)hoop(dot)co(dot)uk>
To: <pgsql-general(at)postgreSQL(dot)org>
Subject: trouble updating
Date: 1999-10-12 21:59:03
Message-ID: 026201bf14fd$06a94060$0501a8c0@noonoo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I would like to update about 50000 records from a table of 1000000. The ids
of records that I _don't_ want to update are in a similar table (containing
some 950000 records).

What is the best way to construct my SQL statement?

TIA

timj

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Perkins 1999-10-12 22:04:24 Technical Discussion at Linux Showcase Conference
Previous Message Charles Tassell 1999-10-12 20:52:28 Re: [GENERAL] two serial fields within one table?