| From: | Kovacs Zoltan <kovacsz(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu> |
|---|---|
| To: | Philip Warner <pjw(at)rhyme(dot)com(dot)au> |
| Cc: | pgsql-hackers(at)postgresql(dot)org, tgl(at)sss(dot)pgh(dot)pa(dot)us |
| Subject: | Re: Odd results in SELECT |
| Date: | 2001-05-10 16:50:01 |
| Message-ID: | Pine.LNX.4.21.0105101846330.20062-100000@pc10.radnoti-szeged.sulinet.hu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-05-10 17:20:59 | 7.2 items |
| Previous Message | Philip Warner | 2001-05-10 16:32:24 | Odd results in SELECT |