Re: Odd results in SELECT

On Fri, 11 May 2001, Philip Warner wrote:
> Can anyone suggest why this might be happening (I think it's in 7.1b4):
> 
>      SELECT definition as viewdef, 
>          (select oid from pg_rewrite where
>             rulename='_RETszallitolevel_tetele_ervenyes') as view_oid 
>      from pg_views where viewname = 'szallitolevel_tetele_ervenyes';
> 
> => view_oid is 133652.
> 
>  
>      SELECT definition as viewdef, 
>          (select oid from pg_rewrite where 
>             rulename='_RET' || 'szallitolevel_tetele_ervenyes') as view_oid 
>      from pg_views where viewname = 'szallitolevel_tetele_ervenyes';
> 
> => view_oid is NULL
I get the same result in 7.1 final. Tom, isn't this in relation with my
complex query you solved yesterday?

Zoltan