MIME-Version: 1.0
References: 
 <CAJOWwD5_saumY5Xv1QAQ=VxwMQrz-tF6G-Fwek-ew52-=_uOXg@mail.gmail.com>
 <acppj9U8zquc2O7z@depesz.com>
In-Reply-To: <acppj9U8zquc2O7z@depesz.com>
From: Ibrahim Shaame <ishaame@gmail.com>
Date: Mon, 30 Mar 2026 17:22:53 +0300
Message-ID: 
 <CAJOWwD5XcMzwMrkaL-vD8d553y0BzQBppObZhau6zYxA4hj5nw@mail.gmail.com>
Subject: Re: Adding column in a recursive query
To: depesz@depesz.com
Cc: "pgsql-novice@lists.postgresql.org" <pgsql-novice@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000011cd42064e3e97fb"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJOWwD5XcMzwMrkaL-vD8d553y0BzQBppObZhau6zYxA4hj5nw%40mail.gmail.com>
Precedence: bulk

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

Hello Hubert.
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 not
been able to identify.
Regards
Ibrahim

On Mon, Mar 30, 2026 at 3:16=E2=80=AFPM hubert depesz lubaczewski <depesz@d=
epesz.com>
wrote:

> On Mon, Mar 30, 2026 at 01:20:14PM +0300, Ibrahim Shaame wrote:
> > I have a working recursive query. I want to add another column, but it
> > gives me an error:
> > ERROR:  operator does not exist: integer =3D text
> > LINE 21:           WHERE e.nasaba_1 =3D x_1.namba
> >                                     ^
> > HINT:  No operator matches the given name and argument types. You might
> > need to add explicit type casts.
> > Any suggestion of where I am doing it wrong?
>
> You can't compare text and integer.
>
> Does 'abc' equal 0 ?
> What about '01' and 1 ?
>
> Cast one side to the type of the other. Or, better yet, normalize
> datatypes in tables, so that you don't have to compare across types.
>
> Best regards,
>
> depesz
>
>

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

<div dir=3D"ltr"><div>Hello Hubert.=C2=A0</div><div>Thanks for the reply. B=
oth are integers and they work well without the two lines. So what changed =
one of them to text. Can you see where? I have not been able to identify.</=
div><div>Regards</div><div>Ibrahim</div></div><br><div class=3D"gmail_quote=
 gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, Mar 3=
0, 2026 at 3:16=E2=80=AFPM hubert depesz lubaczewski &lt;<a href=3D"mailto:=
depesz@depesz.com">depesz@depesz.com</a>&gt; wrote:<br></div><blockquote cl=
ass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid=
 rgb(204,204,204);padding-left:1ex">On Mon, Mar 30, 2026 at 01:20:14PM +030=
0, Ibrahim Shaame wrote:<br>
&gt; I have a working recursive query. I want to add another column, but it=
<br>
&gt; gives me an error:<br>
&gt; ERROR:=C2=A0 operator does not exist: integer =3D text<br>
&gt; LINE 21:=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0WHERE e.nasaba_1 =3D =
x_1.namba<br>
&gt;=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0^<br>
&gt; HINT:=C2=A0 No operator matches the given name and argument types. You=
 might<br>
&gt; need to add explicit type casts.<br>
&gt; Any suggestion of where I am doing it wrong?<br>
<br>
You can&#39;t compare text and integer.<br>
<br>
Does &#39;abc&#39; equal 0 ?<br>
What about &#39;01&#39; and 1 ?<br>
<br>
Cast one side to the type of the other. Or, better yet, normalize<br>
datatypes in tables, so that you don&#39;t have to compare across types.<br=
>
<br>
Best regards,<br>
<br>
depesz<br>
<br>
</blockquote></div>

--00000000000011cd42064e3e97fb--