7;
Sent: Wednesday, March 21, 2012 4:31 PM
Subject: Re: [GENERAL] strange result with union
Thus view1 must be returning 3 pairs of duplicate rows which are then being
combined into 3 individual rows during the de-duplication pass.
Dave J.
From:pgsql-general-ow...@postgresql.org
[mai
11:26 AM
To: pgsql
Subject: [GENERAL] strange result with union
Hello,
Today, I have encounterd a strange result and I want to trace it but I do
not know how. I have two views having union as in q3. q1 returns 236 rows,
q2 returns 0 rows. I expected q3 to return 236 rows but I get 233
Hello,
Today, I have encounterd a strange result and I want to trace it but I do not
know how. I have two views having union as in q3. q1 returns 236 rows, q2
returns 0 rows. I expected q3 to return 236 rows but I get 233 ...
q1: select * FROM view1 -- reurns 236 rows
q2: select * FROM view2
