MIME-Version: 1.0
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>
In-Reply-To: <2006840.1774881078@sss.pgh.pa.us>
From: Ibrahim Shaame <ishaame@gmail.com>
Date: Mon, 30 Mar 2026 18:11:08 +0300
Message-ID: 
 <CAJOWwD6GpzqUjz6dn+3ye2fRz83EK6eb_buZ18bv4f_iENTJOw@mail.gmail.com>
Subject: Re: Adding column in a recursive query
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: depesz@depesz.com,
	"pgsql-novice@lists.postgresql.org" <pgsql-novice@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000009b3230064e3f431b"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJOWwD6GpzqUjz6dn%2B3ye2fRz83EK6eb_buZ18bv4f_iENTJOw%40mail.gmail.com>
Precedence: bulk

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

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?

Thanks again
Ibrahim

On Mon, Mar 30, 2026 at 5:31=E2=80=AFPM Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Ibrahim Shaame <ishaame@gmail.com> writes:
> > Thanks for the reply. Both are integers and they work well without the
> two
> > lines. So what changed one of them to text. Can you see where? I have n=
ot
> > been able to identify.
>
> This bit is forcing the column names for just the first three
> output columns, leaving the rest to default from the SELECT
> targetlist:
>
>         WITH RECURSIVE x(jina, namba, nasaba_1) AS (
>
> That's a hazardous practice: usually I'd force all or none of
> the column names that way.  In this case, I speculate that you
> carelessly added the new column as one of the physically first
> three SELECT outputs, and didn't adjust this list to match,
> leading to confusion about which column is "x.namba".
>
> If that's not it, you need to be a great deal more specific
> about exactly how you changed the query.
>
>                         regards, tom lane
>

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

<div dir=3D"ltr"><div>Effectively, after removing the column names from x(<=
span class=3D"gmail-im">jina, namba, nasaba_1) it works now. Thank you very=
 much. But then I don&#39;t understand the advantage or inconvenience=C2=A0=
of naming or not naming the columns there. Is there any explanation somewhe=
re?</span></div><div><span class=3D"gmail-im"><br></span></div><div><span c=
lass=3D"gmail-im">Thanks again</span></div><div><span class=3D"gmail-im">Ib=
rahim</span></div></div><br><div class=3D"gmail_quote gmail_quote_container=
"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, Mar 30, 2026 at 5:31=E2=80=
=AFPM Tom Lane &lt;<a href=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</=
a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0p=
x 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Ib=
rahim Shaame &lt;<a href=3D"mailto:ishaame@gmail.com" target=3D"_blank">ish=
aame@gmail.com</a>&gt; writes:<br>
&gt; Thanks for the reply. Both are integers and they work well without the=
 two<br>
&gt; lines. So what changed one of them to text. Can you see where? I have =
not<br>
&gt; been able to identify.<br>
<br>
This bit is forcing the column names for just the first three<br>
output columns, leaving the rest to default from the SELECT<br>
targetlist:<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 WITH RECURSIVE x(jina, namba, nasaba_1) AS (<br=
>
<br>
That&#39;s a hazardous practice: usually I&#39;d force all or none of<br>
the column names that way.=C2=A0 In this case, I speculate that you<br>
carelessly added the new column as one of the physically first<br>
three SELECT outputs, and didn&#39;t adjust this list to match,<br>
leading to confusion about which column is &quot;x.namba&quot;.<br>
<br>
If that&#39;s not it, you need to be a great deal more specific<br>
about exactly how you changed the query.<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br>
</blockquote></div>

--0000000000009b3230064e3f431b--