Postgres Pro
Downloads
Home   >   mailing lists

trouble updating - Mailing list pgsql-general

From Tim Joyce
Subject trouble updating
Date
Msg-id 026201bf14fd$06a94060$0501a8c0@noonoo
Whole thread Raw
In response to Re: [GENERAL] stored procedure revisited  (Herouth Maoz <herouth@oumail.openu.ac.il>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Charles Tassell
Date:
Subject: Re: [GENERAL] two serial fields within one table?
Next
From: Scott Perkins
Date:
Subject: Technical Discussion at Linux Showcase Conference