Horton

Re: [HACKERS] JOIN syntax. Examples?

Oliver Elphick <olly@lfix.co.uk>

View thread
From: "Oliver Elphick" <olly@lfix.co.uk>
To: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Cc: "Jackson, DeJuan" <djackson@cpsgroup.com>, Dan Gowin <DGowin@avantec.net>, "PGSQL HACKERS (E-mail)" <pgsql-hackers@postgreSQL.org>
Date: 1998-12-11T22:35:18Z
Lists: pgsql-hackers 
"Thomas G. Lockhart" wrote:
  >Does anyone have a non-M$ RDBMS which implements SQL92 joins?
 
The book "The Practical SQL Handbook", which is often recommended on
these lists, uses the syntax `*=' and `=*' for left and right outer
joins (page 211).  I think we ought to support this syntax as well,
since it will save new users from confusion.

-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
               PGP key from public servers; key ID 32B8FAA1
                 ========================================
     "The spirit of the Lord GOD is upon me; because the 
      LORD hath anointed me to preach good tidings unto the 
      meek; he hath sent me to bind up the brokenhearted, to
      proclaim liberty to the captives, and the opening of 
      the prison to them that are bound."                 
                                        Isaiah 61:1