Odd results in SELECT
От
Philip Warner
Тема
Odd results in SELECT
Дата
Msg-id
3.0.5.32.20010511023224.027ed720@mail.rhyme.com.au
Список
Дерево обсуждения
Odd results in SELECT Philip Warner <pjw@rhyme.com.au>
Re: Odd results in SELECT Tom Lane <tgl@sss.pgh.pa.us>
Re: Odd results in SELECT Kovacs Zoltan <kovacsz@pc10.radnoti-szeged.sulinet.hu>
Re: Odd results in SELECT Tom Lane <tgl@sss.pgh.pa.us>
Re: Odd results in SELECT Kovacs Zoltan <kovacsz@pc10.radnoti-szeged.sulinet.hu>
Re: Odd results in SELECT Tom Lane <tgl@sss.pgh.pa.us>
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
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \| | --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/
В списке pgsql-hackers по дате отправления
