Hi Scott,
Thanks for the clarification!
Sarwar
From: Scott Ribe <scott_ribe@elevated-dev.com>
Sent: Saturday, May 4, 2024 8:52 PM
To: M Sarwar <sarwarmd02@outlook.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: ERROR: return and sql tuple descriptions are incompatible
> On May 4, 2024, at 6:38 PM, M Sarwar <sarwarmd02@outlook.com> wrote:
>
> Are you suggesting me to use the type either TEXT or some other data type in the below clause of the SQL.
No, but if you want them both in the same column of your output, then one or the other must be cast so the column type is consistent.
