Re: function to_char(unknown) is not unique at character 8

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: function to_char(unknown) is not unique at character 8
Date: 2023-07-06 14:01:43
Message-ID: 937cdcff-5ecd-afdf-8b86-64c0c6c982fa@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/6/23 04:19, gzh wrote:
>
> Hi,
>
>
> I upgraded the version of PostgreSQL from 12.6 to 12.13,
>
> when I execute the sql below , the to_char function caused the following
> error.
>
>
> ---------------SQL------------------
>
> select TO_CHAR('1000000');
>

Isn't '1000000' already a character string?

How do you convert a character string to a character string?

--
Born in Arizona, moved to Babylonia.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2023-07-06 14:07:23 Re: function to_char(unknown) is not unique at character 8
Previous Message Mateusz Henicz 2023-07-06 12:44:53 Re: Logical replication restarts