Bug with view definition?

[Sebastian Böck <sebastianboeck@xxxxxxxxxx>]

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq