Re: ERROR: return and sql tuple descriptions are incompatible

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: M Sarwar <sarwarmd02(at)outlook(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: ERROR: return and sql tuple descriptions are incompatible
Date: 2024-05-05 00:52:56
Message-ID: EAD3D4F4-C394-4E72-B782-31CF9634A040@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On May 4, 2024, at 6:38 PM, M Sarwar <sarwarmd02(at)outlook(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Erik Wienhold 2024-05-05 00:56:21 Re: ERROR: return and sql tuple descriptions are incompatible
Previous Message M Sarwar 2024-05-05 00:38:34 Re: ERROR: return and sql tuple descriptions are incompatible