Dnia Sat, Mar 19, 2005 at 06:36:27PM +0100, [EMAIL PROTECTED] napisal(a/o): > 1. I've a master table containing about 40000 records. A count(*) provides > me the exact number. > 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. select .... only .... (read queries-table-expressions.html from PostgreSQL documentation, then read rest of documentation).
> Did someone have this problem before? > I'm using 8.0 Windows XP en the pgAdmin III , r1.2.0 I don't have any XP problem ;> (sorry, lame joke) > I even tried the same on the command line! me too :>>>> -- ojciec ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
