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 PM hubert depesz lubaczewski <depesz@depesz.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 = text > LINE 21: WHERE e.nasaba_1 = 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.
