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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Stefan Huber | 2000-10-24 08:51:19 | Re: v7 and ODBC Readonly |
Previous Message | Samuel Greenfeld | 2000-10-22 04:41:39 | Postgres and Macintosh Clients |