insert into master_nl
select * from master where substr(loc,1,2) = 'NL'
>-- Oorspronkelijk bericht --
>Subject: Re: [GENERAL] Question insert data
>From: Ragnar Hafstað <gnari@simnet.is>
>To: perico@12move.nl
>Cc: pgsql-general@postgresql.org
>Date: Sat, 19 Mar 2005 17:56:52 +0000
>
>
>On Sat, 2005-03-19 at 18:36 +0100, perico@12move.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