On Mon, Jan 24, 2005 at 12:29:12PM +0800, Öܵ½¾© wrote:
> I have a table with 500,000 records which has some invalid records,
> I had wrote a program to check it, by the program I get all OIDs of
> the redundant records, so I use "delete from tableXXX where oid =XXX1
> or oid =XXX2 or oid =XXX3 .
When grilled further on (Mon, 24 Jan 2005 12:29:12 +0800),
Öܵ½¾© <[EMAIL PROTECTED]> confessed:
> I have a table with 500,000 records which has some invalid records, I had
> wrote a program to check it, by the program I get all OIDs of the redundant
> records, so I use "delete from tableXXX wher
I have a table with 500,000 records which has some invalid records, I had wrote
a program to check it, by the program I get all OIDs of the redundant records,
so I use "delete from tableXXX where oid =XXX1 or oid =XXX2 or oid =XXX3 ... or
oid=XXX1000, but it take me a long time to complete thi