From: | perico(at)12move(dot)nl |
---|---|
To: | Ragnar Hafstað <gnari(at)simnet(dot)is> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Betr: Re: Question insert data |
Date: | 2005-03-19 19:59:38 |
Message-ID: | 421C515F0001B8FD@mail-4-bnl.tiscali.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(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
From | Date | Subject | |
---|---|---|---|
Next Message | Bill Aten | 2005-03-19 20:06:27 | CFV: comp.databases.postgresql |
Previous Message | Andrus Moor | 2005-03-19 19:55:22 | How to get concecutive id values |