public inbox for [email protected]  

help / color / mirror / Atom feed

From: Ibrahim Shaame <[email protected]>
To: David G. Johnston <[email protected]>
Cc: Tom Lane <[email protected]>
Cc: [email protected] <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Adding column in a recursive query
Date: Sun, 5 Apr 2026 13:01:09 +0300
Message-ID: <CAJOWwD5-b-vyGWuRJ06SqGTy0gcOFcG_+GENi=oWV4e4heLLcA@mail.gmail.com> (raw)
In-Reply-To: <CAKFQuwagw6CHy9qOVeDYeNa3_r8DpVTaR-u_xE9vGgw0EXQ7Sg@mail.gmail.com>
References: <CAJOWwD5_saumY5Xv1QAQ=VxwMQrz-tF6G-Fwek-ew52-=_uOXg@mail.gmail.com>
	<[email protected]>
	<CAJOWwD5XcMzwMrkaL-vD8d553y0BzQBppObZhau6zYxA4hj5nw@mail.gmail.com>
	<[email protected]>
	<CAJOWwD6GpzqUjz6dn+3ye2fRz83EK6eb_buZ18bv4f_iENTJOw@mail.gmail.com>
	<CAKFQuwagw6CHy9qOVeDYeNa3_r8DpVTaR-u_xE9vGgw0EXQ7Sg@mail.gmail.com>

Thank you David for clarifying

.
Ibrahim Shaame

On Mon, Mar 30, 2026 at 6:18 PM David G. Johnston <
[email protected]> wrote:

> On Monday, March 30, 2026, Ibrahim Shaame <[email protected]> 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’t 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.
>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Adding column in a recursive query
  In-Reply-To: <CAJOWwD5-b-vyGWuRJ06SqGTy0gcOFcG_+GENi=oWV4e4heLLcA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox