Paul McGarry wrote:
> If I do a 'SELECT * from view_name' and get 8 rows of data, when I
> do a 'SELECT count(*) from view_name' I get 8 rows of the
> number 1 returned.
I've attached a script which will generate a bunch of tables and
a view then do a select * and select count(*) on that view. It
is almost certainly to do with the GROUPing used in the view.
The ouput I get is:
select * from entry_view;
id | description_text | parent_id | minamount
----+------------------+-----------+-----------
1 | entry one | 0 | 1
2 | entry two | 1 | 2
3 | entry three | 2 | 7
(3 rows)
select count(*) from entry_view;
count
-------
2
2
1
(3 rows)
That doesn't make much sense to me...
Postgres 7.0.2 by the way.
I'll work on the more complex case where I got the
ERROR: ExecEvalAggref error message now.
--
Paul McGarry mailto:[EMAIL PROTECTED]
Systems Integrator http://www.opentec.com.au
Opentec Pty Ltd http://www.iebusiness.com.au
6 Lyon Park Road Phone: (02) 9878 1744
North Ryde NSW 2113 Fax: (02) 9878 1755
countbug.sql
