MIME-Version: 1.0
In-Reply-To: 
 <CAJOWwD6GpzqUjz6dn+3ye2fRz83EK6eb_buZ18bv4f_iENTJOw@mail.gmail.com>
References: 
 <CAJOWwD5_saumY5Xv1QAQ=VxwMQrz-tF6G-Fwek-ew52-=_uOXg@mail.gmail.com>
 <acppj9U8zquc2O7z@depesz.com>
 <CAJOWwD5XcMzwMrkaL-vD8d553y0BzQBppObZhau6zYxA4hj5nw@mail.gmail.com>
 <2006840.1774881078@sss.pgh.pa.us>
 <CAJOWwD6GpzqUjz6dn+3ye2fRz83EK6eb_buZ18bv4f_iENTJOw@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Mon, 30 Mar 2026 08:18:09 -0700
Message-ID: 
 <CAKFQuwagw6CHy9qOVeDYeNa3_r8DpVTaR-u_xE9vGgw0EXQ7Sg@mail.gmail.com>
Subject: Re: Adding column in a recursive query
To: Ibrahim Shaame <ishaame@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, "depesz@depesz.com" <depesz@depesz.com>,
	"pgsql-novice@lists.postgresql.org" <pgsql-novice@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000db523b064e3f5b7b"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwagw6CHy9qOVeDYeNa3_r8DpVTaR-u_xE9vGgw0EXQ7Sg%40mail.gmail.com>
Precedence: bulk

--000000000000db523b064e3f5b7b
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Monday, March 30, 2026, Ibrahim Shaame <ishaame@gmail.com> wrote:

> Effectively, after removing the column names from x(jina, namba,
> nasaba_1) it works now. Thank you very much. But then I don't understand
> the advantage or inconvenience of naming or not naming the columns there.
> Is there any explanation somewhere?
>

SQL is big on providing ways to give aliases/names to things.  It just
boils down to readability or, more often, conventions, as to which ones to
use.  The CTE column names clause doesn=E2=80=99t get used much that I have=
 seen.
You have to write a full query inside the CTE anyway so column aliases are
more conventional.

David J.

--000000000000db523b064e3f5b7b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Monday, March 30, 2026, Ibrahim Shaame &lt;<a href=3D"mailto:ishaame@gma=
il.com">ishaame@gmail.com</a>&gt; wrote:<br><blockquote class=3D"gmail_quot=
e" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">=
<div dir=3D"ltr"><div>Effectively, after removing the column names from x(<=
span>jina, namba, nasaba_1) it works now. Thank you very much. But then I d=
on&#39;t understand the advantage or inconvenience=C2=A0of naming or not na=
ming the columns there. Is there any explanation somewhere?</span></div><di=
v></div></div></blockquote><div><br></div><div>SQL is big on providing ways=
 to give aliases/names to things.=C2=A0 It just boils down to readability o=
r, more often, conventions, as to which ones to use.=C2=A0 The CTE column n=
ames clause doesn=E2=80=99t get used much that I have seen.=C2=A0 You have =
to write a full query inside the CTE anyway so column aliases are more conv=
entional.</div><div><br></div><div>David J.=C2=A0</div>

--000000000000db523b064e3f5b7b--