
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*)


Wed, 22 Jul 1998 19:05:45 -0700 (PDT)
Brett McCormick <pgsql@chicken.org>
subselects & views
I think this is fixed in 6.4.  Beta is September 1.

> 
> 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*)
> 
> 
> 


-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

Sat, 22 Aug 1998 00:09:29 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] subselects & views