Skip site navigation (1) Skip section navigation (2)

is this a bug in PG 7?

From: Rainer Mager <rmager(at)vgkk(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: is this a bug in PG 7?
Date: 2000-10-24 04:19:30
Message-ID: 39F50DD2.11286367@vgkk.com (view raw or flat)
Thread:
Lists: pgsql-admin
In PG 7.0.2, I have a select:

SELECT pr_category_id, pr_category_id FROM pr_category
    UNION SELECT pr_category_id, parent_cat FROM pr_category WHERE parent_cat
<> 0
    UNION SELECT pr_category_id, parent_cat_link FROM pr_category_link

when I run this I get a subset of the correct results. If I move the first
select to the end as in:

SELECT pr_category_id, parent_cat FROM pr_category WHERE parent_cat <> 0
    UNION SELECT pr_category_id, parent_cat_link FROM pr_category_link
    UNION SELECT pr_category_id, pr_category_id FROM pr_category

then it works correctly.

Any ideas? Is this a bug?


Thanks,


--

\\\\\    ///    Rainer Mager
 \\\\\  ///
  \\\VANGUARD   Ever Green Bldg., 5F
   \\\///       3-3-2 Naka-Meguro, Meguro-ku, Tokyo 153-0061
    \\//        Phone: 5768-2855  Fax: 5768-2856
     \/         Email: rmager(at)vgkk(dot)co(dot)jp  Web: www.vgkk.co.jp




In response to

pgsql-admin by date

Next:From: Stefan HuberDate: 2000-10-24 08:51:19
Subject: Re: v7 and ODBC Readonly
Previous:From: Samuel GreenfeldDate: 2000-10-22 04:41:39
Subject: Postgres and Macintosh Clients

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group