Re: ERROR: return and sql tuple descriptions are incompatible

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Scott,
Thanks for the clarification!
Sarwar


From: Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx>
Sent: Saturday, May 4, 2024 8:52 PM
To: M Sarwar <sarwarmd02@xxxxxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Subject: Re: ERROR: return and sql tuple descriptions are incompatible
 
> On May 4, 2024, at 6:38 PM, M Sarwar <sarwarmd02@xxxxxxxxxxx> 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.


[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux