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