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
---------------------------(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
