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

pgsql-server/doc/src/sgml/ref select.sgml

From: momjian(at)postgresql(dot)org (Bruce Momjian - CVS)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql-server/doc/src/sgml/ref select.sgml
Date: 2003-03-20 19:00:01
Message-ID: 20030320190001.E6473476369@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
CVSROOT:	/cvsroot
Module name:	pgsql-server
Changes by:	momjian(at)postgresql(dot)org	03/03/20 14:00:01

Modified files:
	doc/src/sgml/ref: select.sgml 

Log message:
	The documentation for SELECT is incorrect in a sense: the syntax for a
	join is defined as:
	
	from_item [ NATURAL ] join_type from_item
	[ ON join_condition | USING ( join_column_list ) ]
	
	However, if the join_type is an INNER or OUTER join, an ON, USING, or
	NATURAL clause *must* be specified (it's not optional, as that segment
	of the docs suggest).
	
	I'm not exactly sure what the best way to fix this is, so I've attached
	a patch adding a FIXME comment to the relevant section of the SGML. If
	anyone has any ideas on the proper way to outline join syntax, please
	speak up.
	
	Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC


pgsql-committers by date

Next:From: Bruce Momjian - CVSDate: 2003-03-20 20:05:32
Subject: pgsql-server/doc/src/sgml/ref alter_user.sgml
Previous:From: Bruce Momjian - CVSDate: 2003-03-20 18:59:18
Subject: pgsql-server/contrib/btree_gist Makefile READM ...

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