On Tue, Sep 27, 2005 at 09:17:18AM +0100, Keith Randall wrote:
> I'm missing a row when I generate a table off a view.
>
> select count(*) from foo;
>
> 20811
>
> select * into temp from foo;
> select count(*) from temp;
>
> 20810
Interesting. I can duplicate this behavior here. However, what's even
more interesting, is that 8.0 returns 20814 rows in both cases, so
something _is_ wrong.
It may be related to the latest outer join bug, which Tom Lane fixed
yesterday or the day before. I'll recompile and retest.
--
Alvaro Herrera http://www.amazon.com/gp/registry/5ZYLFMCVHXC
"Uno combate cuando es necesario... ¡no cuando está de humor!
El humor es para el ganado, o para hacer el amor, o para tocar el
baliset. No para combatir." (Gurney Halleck)