Re: Odd results in SELECT

On Thu, 10 May 2001, Tom Lane wrote:

> Philip Warner <pjw(at)rhyme(dot)com(dot)au> writes:
> > Can anyone suggest why this might be happening (I think it's in 7.1b4):
>
> Can't duplicate in current sources:
>
> regression=# SELECT definition as viewdef,
> regression-# (select oid from pg_rewrite where
> regression(# rulename='_RETstreet') as view_oid
> regression-# from pg_views where viewname = 'street';
> viewdef
> | view_oid
> -------------------------------------------------------------------------------------------------+----------
> SELECT r.name, r.thepath, c.cname FROM ONLY road r, real_city c WHERE (c.outline ## r.thepath); | 4001276
> (1 row)
>
> regression=# SELECT definition as viewdef,
> regression-# (select oid from pg_rewrite where
> regression(# rulename='_RET' || 'street') as view_oid
> regression-# from pg_views where viewname = 'street';
> viewdef
> | view_oid
> -------------------------------------------------------------------------------------------------+----------
> SELECT r.name, r.thepath, c.cname FROM ONLY road r, real_city c WHERE (c.outline ## r.thepath); | 4001276
> (1 row)
>
> What does EXPLAIN show for your two queries? (Maybe you'd better make
> it EXPLAIN VERBOSE.)
I attached both.

Kov\'acs, Zolt\'an
kovacsz(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu
http://www.math.u-szeged.hu/~kovzol
ftp://pc10.radnoti-szeged.sulinet.hu/home/kovacsz