Bug with view definition?

Поиск
Список
Период
Сортировка
От Sebastian Böck
Тема Bug with view definition?
Дата
Msg-id 42A70E95.5000505@freenet.de
обсуждение исходный текст
Ответы Re: Bug with view definition?
Re: Bug with view definition?
Список pgsql-general
Hello all,

why is the last definition of a view not working, although the
documentation says all three are equal?

Testcase:

CREATE SCHEMA one;
CREATE SCHEMA two;

CREATE TABLE one.one (
    id SERIAL PRIMARY KEY
);

CREATE TABLE two.two (
    id SERIAL PRIMARY KEY
);

CREATE TABLE join1 (
    id SERIAL PRIMARY KEY
);

CREATE OR REPLACE VIEW working AS
    SELECT one.*
    FROM one.one
    JOIN two.two ON TRUE
    JOIN join1 ON join1.id = one.id;

CREATE OR REPLACE VIEW also_working AS
    SELECT one.*
    FROM one.one
    CROSS JOIN two.two
    JOIN join1 ON join1.id = one.id;

CREATE OR REPLACE VIEW not_working AS
    SELECT one.*
    FROM one.one, two.two
    JOIN join1 ON join1.id = one.id;

Thanks in advance

Sebastian

В списке pgsql-general по дате отправления: