[EMAIL PROTECTED] writes:
> Now i will create two views:
> P1V:
> select order_id as id1, count(*) as count1 from order_item where state=1 group by
>order_id;
> P2V:
> select order_id as id2, count(*) as count2 from order_item where state=2 group by
>order_id;
Grouped views don't work very w
> PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66
>
> wrong results when joining views.
Upgrade to the latest version (7.1.3).
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---(end of broadcast)---
Vladimir Bezak ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
joining views
Long Description
PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66
wrong results when joining views.
Sample Code
table ORDER_
