Postgres Pro
Downloads
Home   >   mailing lists

Re: function to_char(iso-8859-1) is not unique at character 8 - Mailing list pgsql-general

From Ron
Subject Re: function to_char(iso-8859-1) is not unique at character 8
Date
Msg-id 937cdcff-5ecd-afdf-8b86-64c0c6c982fa@gmail.com
Whole thread Raw
In response to function to_char(iso-8859-1) is not unique at character 8  (gzh <gzhcoder@126.com>)
Responses Re: function to_char(iso-8859-1) is not unique at character 8
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Mateusz Henicz
Date:
Subject: Re: Logical replication restarts
Next
From: Tom Lane
Date:
Subject: Re: function to_char(iso-8859-1) is not unique at character 8