Re: Question insert data
От | Marcin Piotr Grondecki |
---|---|
Тема | Re: Question insert data |
Дата | |
Msg-id | 20050319184609.GA11068@localhost.localdomain обсуждение исходный текст |
Ответ на | Question insert data (perico@12move.nl) |
Список | pgsql-general |
Dnia Sat, Mar 19, 2005 at 06:36:27PM +0100, perico@12move.nl 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
В списке pgsql-general по дате отправления: