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

Re: [HACKERS] JOIN syntax. Examples?

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
Cc: "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com>, Dan Gowin <DGowin(at)avantec(dot)net>, "PGSQL HACKERS (E-mail)" <pgsql-hackers(at)postgreSQL(dot)org>, "Matthew N(dot) Dodd" <winter(at)jurai(dot)net>
Subject: Re: [HACKERS] JOIN syntax. Examples?
Date: 1998-12-12 04:02:38
Message-ID: 3671EADE.8A572A0@alumni.caltech.edu (view raw or flat)
Thread:
Lists: pgsql-hackers
> 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.

This one conflicts with Postgres' operator extensibility features, since
it would look just like a legal operator.

The two books I have at hand (besides my old Ingres docs) are A Guide to
the SQL Standard by Date and Darwen and Understanding the New SQL by
Melton and Simon. Both focus on SQL standard syntax, and neither mention
the various outer join syntaxes accepted by Oracle, Informix, or Sybase.

An explanation for the lack of standards compliance by the big three
probably involves the fact that they predate the standard by a
significant number of years.

                    - Tom

In response to

Responses

pgsql-hackers by date

Next:From: Pascal AndrDate: 1998-12-12 08:44:18
Subject: Re: [HACKERS] 6.4.1 release
Previous:From: Bruce MomjianDate: 1998-12-12 03:56:53
Subject: Re: [HACKERS] v6.4 - duplicate entries in announce

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