Hi There, I've a problem with inserting data and I can't figure out what the problem is:
what did I do: 1. I've a master table containing about 40000 records. A count(*) provides me the exact number. 2. I've create a table based on from the master. I copied a fraction from the master into the new table using a where clause (insert into ... select * from ... where a = b . The number of records copied is about 2553. Issueing the same select statement on the master table gives me a list of 5106 which is twice the number of copied records. Did someone have this problem before? I'm using 8.0 Windows XP en the pgAdmin III , r1.2.0 I even tried the same on the command line! thanks, Peter _____________________________________________________________________ 12move ADSL vanaf 18,95 euro! GRATIS modem, GEEN aansluitkosten en GEEN datalimiet! Ga nu naar http://adsl.12move.nl ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
