Thread
-
Re: [HACKERS] JOIN syntax. Examples?
Oliver Elphick <olly@lfix.co.uk> — 1998-12-11T22:35:18Z
"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 -
Re: [HACKERS] JOIN syntax. Examples?
Matthew N. Dodd <winter@jurai.net> — 1998-12-11T23:39:58Z
On Fri, 11 Dec 1998, Oliver Elphick wrote: > 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. 'A Guide to The SQL Standard" (4th Ed.) seems to indicate that the MS syntax is fairly close. ISBN 0-201-96426-0 -- | Matthew N. Dodd | 78 280Z | 75 164E | 84 245DL | FreeBSD/NetBSD/Sprite/VMS | | winter@jurai.net | This Space For Rent | ix86,sparc,m68k,pmax,vax | | http://www.jurai.net/~winter | Are you k-rad elite enough for my webpage? |
-
Re: [HACKERS] JOIN syntax. Examples?
Thomas Lockhart <lockhart@alumni.caltech.edu> — 1998-12-12T04:02:38Z
> 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 -
Re: [HACKERS] JOIN syntax. Examples?
Hannu Krosing <hannu@trust.ee> — 1998-12-14T19:10:52Z
Thomas G. Lockhart wrote: > > > 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. so does = Could it be possible to extend the operator extensibility features to achieve the behaviour of outer/cross joins ? > 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. Has anybody tried out DB2 ? I have downloaded it (for linux) but have not yet tried it. > 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. Not to mention that both =* and =(+) are more concise and easier to follow, at least for one with my headshape. The standard is probably the 'worst common denominator' or something like that :( ----------------- Hannu
-
Re: [HACKERS] JOIN syntax. Examples?
Thomas Lockhart <lockhart@alumni.caltech.edu> — 1998-12-15T01:01:01Z
> > This one conflicts with Postgres' operator extensibility features, > > since it would look just like a legal operator. > so does = But in fact its usage for joins matches the typical usage elsewhere. > Has anybody tried out DB2 ? > I have downloaded it (for linux) but have not yet tried it. Just downloaded it this morning (and afternoon, it's a thin pipe at home for 60MB of files :) Have you looked at what it takes to do an installation yet? > Not to mention that both =* and =(+) are more concise and easier to > follow, at least for one with my headshape. > The standard is probably the 'worst common denominator' or something > like that :( DeJuan points out a major strength of the SQL92 syntax, which allows multiple outer joins in the same query. One of my books shows an example: select * from q1 full outer join q2 on (q1.id = q2.id) full outer join q3 on (coalesce(q1.id,q2.id)=q3.id) full outer join q4 on (coalesce(q1.id,q2.id,q3.id)=q4.id) I suppose one can do something similar using a *= operator by using parentheses? Not sure though... - Tom -
Re: [HACKERS] JOIN syntax. Examples?
Thomas Lockhart <lockhart@alumni.caltech.edu> — 1998-12-15T01:20:47Z
> > Has anybody tried out DB2 ? > > I have downloaded it (for linux) but have not yet tried it. > Just downloaded it this morning (and afternoon, it's a thin pipe at > home for 60MB of files :) Have you looked at what it takes to do an > installation yet? Well, I'll have to save it for later, at least at home. It's glibc2 only. Also, the tar file has a bunch of rpms but also other files. Don't know what's up with that... - Tom -
Re[2]: [HACKERS] JOIN syntax. Examples?
jose' soares <sferac@bo.nettuno.it> — 1998-12-15T13:43:20Z
Hi all, >> > Has anybody tried out DB2 ? >> > I have downloaded it (for linux) but have not yet tried it. >> Just downloaded it this morning (and afternoon, it's a thin pipe at >> home for 60MB of files :) Have you looked at what it takes to do an >> installation yet? Could someone tell me please where I can download DB2? Thanks, -Jose'-