Date: Thu, 5 Mar 2020 16:45:23 +0900
From: Michael Paquier <michael@paquier.xyz>
To: axykon@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: Possible typos in the #12.1.1 examples
Message-ID: <20200305074523.GX2593@paquier.xyz>
References: <158316348159.30450.16075357948244298217@wrigleys.postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="78WCQgNEg63vc82l"
Content-Disposition: inline
In-Reply-To: <158316348159.30450.16075357948244298217@wrigleys.postgresql.org>
Precedence: bulk


--78WCQgNEg63vc82l
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Mon, Mar 02, 2020 at 03:38:01PM +0000, PG Doc comments form wrote:
> Seems like here the example missed 'm' as an alias and a dot in the `wher=
e`
> clause:
> ... messages m
> ... m.id =3D 12;

This query is valid as-is.

> SELECT m.title || ' ' || m.author || ' ' || m.abstract || ' ' || d.body AS
> document
> FROM messages m, docs d
> WHERE mid =3D did AND mid =3D 12;
>=20
> Possibly, the example missed dots:=20
> ... m.id =3D d.id AND m.id =3D 12;

This one is actually valid as well, as long as both relations don't
use the same column names, but I can see your point to add the aliases
to the quals of the WHERE clause to bring more clarity.
--
Michael

--78WCQgNEg63vc82l
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl5grhMACgkQnvQgOdby
QH0RqxAAmvHdewNQ/O6YT93ja98bnQI1/HkbxT3rrR5vSIAyer8KPEZiAaSxyFy4
oAyUXEp3CnoNxNCF8ZQ7RaFp6VF1td/BGx4HZ+wn88+uo7TS+pk2NLEqs4hRWl4E
pOI3GuKzuUgx5YCtF5VQYXZZdskohaLd2J/DP8GkyZrw/K3H8w2ZqFKTXak4y8+2
kM2NK7HPiZ9Jhf+GjqfrCGFomAkF332hqbgQwamc8uDM85mZ+i6rUE5UAiNkZdj/
Y0FZODA5GFClvuEU85vL/OEBrlRjhPOpszgKqFlXAOhXuZtFyApg4nVY6R+UN7u2
YqaGdvIymOrgl9EL4J3ztcjj8hS6SqfE/Ze1v7XzWQ//P60wwibWRDH//czFPeLM
vRnEk5azfaEy+++JNvKJP1zRpfV0TK7B43uaD+Nh+UjDx7xtngKBZsYnGAVs9MaC
7YS+ra/quvcxhht/uXMaUj113t2Th5H915m0X1AHAm16UPEOkkaUCmlJ9Rfg/HT6
AnopmNUowe/L+4hXyiizYA0/PWzluO0aiIfWDYTMPQ0ZIKc3qxVvd0NYveV9N0en
6duupONhzk154A2U4lQPGvcjJca2qFfi5NrvTDZx6ipHZT52pchRo0GeJqClT9IJ
tF2SY2EmNAP0zKphalEORiy2H0k2spEGtDuuENt8PnZcZCJQdbM=
=NojI
-----END PGP SIGNATURE-----

--78WCQgNEg63vc82l--