Betr: Re: Question insert data

Some more info

select count(*) from master_bart where substr(locode_c5,1,2) = 'NL'

gives me the result: 5106

delete from masterplts_nl;

insert into masterplts_nl
select * from master_bart where substr(locode_c5,1,2) = 'NL';

Query returned successfully: 2553 rows affected, 5127 ms execution time.

>-- Oorspronkelijk bericht --
>Subject: Re: [GENERAL] Question insert data
>From: Ragnar Hafstað <gnari(at)simnet(dot)is>
>To: perico(at)12move(dot)nl
>Cc: pgsql-general(at)postgresql(dot)org
>Date: Sat, 19 Mar 2005 17:56:52 +0000
>
>
>On Sat, 2005-03-19 at 18:36 +0100, perico(at)12move(dot)nl wrote:
>
>> 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.
>
>sounds like you inserted into the master table instead of the new table.
>can you show us the exact SQL you used?
>
>or even better, can you make this happen in a simple test case?
>
>gnari
>
>

_____________________________________________________________________

12move ADSL vanaf 18,95 euro! GRATIS modem, GEEN aansluitkosten en GEEN datalimiet!
Ga nu naar http://adsl.12move.nl