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

Outer joins aren't working with views

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Outer joins aren't working with views
Date: 2000-12-15 12:44:47
Message-ID: 200012151244.eBFCilE09263@hub.org (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
Grzegorz Mucha (mucher(at)tigana(dot)pl) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
Outer joins aren't working with views

Long Description
It seems outer joins are not working at all(they work as inner joins so far).
For example, see below:
(the result is identical for inner and outer join) - two rows fetched from db(as I recall, there should be one more row having t1.id=3)

Sample Code
create table t1(id serial primary key);
create table t2(id2 serial primary key, id int);
insert into t1 values (1);
insert into t1 values (2);
insert into t1 values (3);
insert into t2 (id) values(1);
insert into t2 (id) values(2);
select t1.*, t2.* from t1 natural left outer join t2;

No file was uploaded with this report


Responses

pgsql-hackers by date

Next:From: Oleg BartunovDate: 2000-12-15 15:45:54
Subject: Re: index support for arrays (GiST)
Previous:From: Oleg BartunovDate: 2000-12-15 12:08:26
Subject: Re: index support for arrays (GiST)

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2000-12-15 13:58:06
Subject: Bug in CAST() with time data types
Previous:From: Thomas LockhartDate: 2000-12-15 06:06:57
Subject: Re: compilation error on linux mandrake

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