Re: SELECT documentation

2022-08-31 Thread Bruce Momjian
On Mon, Aug 15, 2022 at 10:53:18PM -0400, Bruce Momjian wrote: > On Sat, Aug 13, 2022 at 10:21:26PM -0400, Tom Lane wrote: > > Bruce Momjian writes: > > > Hi, I agree we should show the more modern JOIN sytax. However, this is > > > just an example, so one example should be sufficient. I went w

Re: SELECT documentation

2022-08-15 Thread Bruce Momjian
On Sat, Aug 13, 2022 at 10:21:26PM -0400, Tom Lane wrote: > Bruce Momjian writes: > > Hi, I agree we should show the more modern JOIN sytax. However, this is > > just an example, so one example should be sufficient. I went with the > > first one in the attached patch. > > You should not remove

Re: SELECT documentation

2022-08-13 Thread Tom Lane
Bruce Momjian writes: > Hi, I agree we should show the more modern JOIN sytax. However, this is > just an example, so one example should be sufficient. I went with the > first one in the attached patch. You should not remove the CROSS JOIN mention at l. 604, first because the references to it j

Re: SELECT documentation

2022-08-13 Thread Bruce Momjian
On Thu, Dec 30, 2021 at 12:11:26AM +0100, Joel Jacobson wrote: > Hi, > > The Examples section in the documentation for the SELECT command [1] > only contains a single example on how to join two tables, > which is written in SQL-89 style: > > SELECT f.title, f.did, d.name, f.date_prod, f.kind >

SELECT documentation

2021-12-29 Thread Joel Jacobson
Hi, The Examples section in the documentation for the SELECT command [1] only contains a single example on how to join two tables, which is written in SQL-89 style: SELECT f.title, f.did, d.name, f.date_prod, f.kind FROM distributors d, films f WHERE f.did = d.did I think it's good to ke