Re: Odd results in SELECT

Kovacs Zoltan <kovacsz@pc10.radnoti-szeged.sulinet.hu> writes:
> 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?

Not in that form --- there isn't any parameter being passed down to the
subquery.  What plan does EXPLAIN show for the failing query?
        regards, tom lane