> 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.
In response to
pgsql-hackers by date
|Next:||From: Pascal Andr||Date: 1998-12-12 08:44:18|
|Subject: Re: [HACKERS] 6.4.1 release|
|Previous:||From: Bruce Momjian||Date: 1998-12-12 03:56:53|
|Subject: Re: [HACKERS] v6.4 - duplicate entries in announce|