insert into master_nl select * from master where substr(loc,1,2) = 'NL' >-- Oorspronkelijk bericht -- >Subject: Re: [GENERAL] Question insert data >From: Ragnar Hafstaš <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Cc: pgsql-general@postgresql.org >Date: Sat, 19 Mar 2005 17:56:52 +0000 > > >On Sat, 2005-03-19 at 18:36 +0100, [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
