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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]