Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <pgsql-novice-owner+archive@lists.postgresql.org>)
	id 1w7Dyp-0055Zh-0r
	for pgsql-novice@arkaria.postgresql.org;
	Mon, 30 Mar 2026 14:52:39 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-novice-owner+archive@lists.postgresql.org>)
	id 1w7Dyn-003zU6-1y
	for pgsql-novice@arkaria.postgresql.org;
	Mon, 30 Mar 2026 14:52:38 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <depesz@depesz.com>)
	id 1w7Dyn-003zTx-0x
	for pgsql-novice@lists.postgresql.org;
	Mon, 30 Mar 2026 14:52:37 +0000
Received: from lana.depesz.com ([88.198.49.178] helo=depesz.com)
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.98.2)
	(envelope-from <depesz@depesz.com>)
	id 1w7Dyl-00000001osL-2EAv
	for pgsql-novice@lists.postgresql.org;
	Mon, 30 Mar 2026 14:52:36 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=depesz.com;
	s=20170201; h=In-Reply-To:Content-Type:MIME-Version:References:Reply-To:
	Message-ID:Subject:Cc:To:Sender:From:Date:Content-Transfer-Encoding:
	Content-ID:Content-Description;
	bh=98RH4WIqJsEfMdE7O7FWOw2d/r6XfbBEWgB32/KTGFI=; b=LTkiXFmjF/hc4JHleXBtiW+LAZ
	FSWAbRw1rbdQYjMjX6FmwcfrAcIYaZ0i2kiyrtOwxqTRElLB3nUEODhtmZgaE16O8jHQ6fEq1gWX/
	QgKh8MV3ItdSWooD47mj5dF11xScCZbwd0im6OXyXWPRlfEtCNCV/J+Gojw/b6C15lu4=;
Received: from depesz by depesz.com with local (Exim 4.96)
	(envelope-from <depesz@depesz.com>)
	id 1w7Dyj-000Fi7-0q;
	Mon, 30 Mar 2026 16:52:33 +0200
Date: Mon, 30 Mar 2026 16:52:33 +0200
From: hubert depesz lubaczewski <depesz@depesz.com>
Sender: depesz@depesz.com
To: Ibrahim Shaame <ishaame@gmail.com>
Cc: "pgsql-novice@lists.postgresql.org" <pgsql-novice@lists.postgresql.org>
Subject: Re: Adding column in a recursive query
Message-ID: <acqOMfQDCKg-RZqU@depesz.com>
Reply-To: depesz@depesz.com
References: 
 <CAJOWwD5_saumY5Xv1QAQ=VxwMQrz-tF6G-Fwek-ew52-=_uOXg@mail.gmail.com>
 <acppj9U8zquc2O7z@depesz.com>
 <CAJOWwD5XcMzwMrkaL-vD8d553y0BzQBppObZhau6zYxA4hj5nw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: 
 <CAJOWwD5XcMzwMrkaL-vD8d553y0BzQBppObZhau6zYxA4hj5nw@mail.gmail.com>
List-Id: <pgsql-novice.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-novice@lists.postgresql.org>
List-Owner: <mailto:pgsql-novice-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-novice>
Archived-At: 
 <https://www.postgresql.org/message-id/acqOMfQDCKg-RZqU%40depesz.com>
Precedence: bulk

On Mon, Mar 30, 2026 at 05:22:53PM +0300, Ibrahim Shaame wrote:
> 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.

Please show *exact* query that fails, and `\d` of table(s) that are
being used.

Best regards,

depesz