:
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('100');
ERROR: function to_char(unknown) is not unique at charact
11:19 odesílatel gzh napsal:
>>
>>> 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.
>>>
>>>
>
the following error.
-------SQL--------------
select TO_CHAR('100');
ERROR: function to_char(unknown) is not unique at character 8
HINT: Could not choose a best candidate function. You might need to add
explicit type casts.
There is no problem before the upgr
to 12.13,
> >> when I execute the sql below , the to_char function caused the following
> >> error.
> >>
> >> -------SQL--
> >> select TO_CHAR('100');
> >>
> >> ERROR: function to_char(unknown)
----SQL----------
>> select TO_CHAR('100');
>>
>> ERROR: function to_char(unknown) is not unique at character 8
>> HINT: Could not choose a best candidate function. You might need to add
>> explicit type casts.
>>
>> There is no problem before
Ron writes:
> On 7/6/23 04:19, gzh wrote:
>> when I execute the sql below , the to_char function caused the following
>> error.
>> select TO_CHAR('100');
> Isn't '100' already a character string?
Nope; in the mind of the Postgres parser, it's a literal of unknown type,
with the actual t
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('100');
Isn't '100' already a character string?
How do
> Hi
>
> čt 6. 7. 2023 v 11:19 odesílatel gzh napsal:
>
>> 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.
>>
>>
>
R: function to_char(unknown) is not unique at character 8
HINT: Could not choose a best candidate function. You might need to add
explicit type casts.
There is no problem before the upgrade and to_char function comes from the
Orafce extension.
The configuration of the old and new dat
> On 06/07/2023 11:19 CEST gzh wrote:
>
> 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('100');
>
>
lect TO_CHAR('100');
>
>
> ERROR: function to_char(unknown) is not unique at character 8
>
> HINT: Could not choose a best candidate function. You might need to add
> explicit type casts.
>
>
> There is no problem before the upgrade and to_char function co
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('100');
ERROR: function to_char(unknown) is not unique at character 8
HI
12 matches
Mail list logo
