subselects & views

select max(ccorderseq) from ccorder;
max
---
603
(1 row)

icv=> select * From the_view where ccorderseq = 603;

[ I get the row back ]

select * From the_view where ccorderseq = (select max(ccorderseq) from ccorder);

I don't get the row back.  nothing has changed, the max value is still
the same.  when I write out the view as a select, the subquery works
and I get the row.

if it makes much of a difference the view is doing a "glob" query (of
a parent and all children, i.e. select from table*)