function to_char(unknown, unknown) is not unique

From: Alex Bozhenko <alexbozhenko(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: function to_char(unknown, unknown) is not unique
Date: 2012-12-10 11:53:19
Message-ID: CAC-xio+60_DUvFg9mBA8NSMYg7btBcDCT0QVACVttWr15WJ-9Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello.

When I'm trying to:
select to_char("ISDate", 'DD.MM.YYYY')::text from register."KSPT_view"
from table, containing nulls in "ISDate", i get nulls and formatted date as
output.

But when I'm trying to:
select to_char(null, 'DD.MM.YYYY')::text

I get a error message:

ERROR: function to_char(unknown, unknown) is not unique
LINE 1: select to_char(null, 'DD.MM.YYYY')::text
^
HINT: Could not choose a best candidate function. You might need to add
explicit type casts.

********** Error **********

ERROR: function to_char(unknown, unknown) is not unique
SQL state: 42725
Hint: Could not choose a best candidate function. You might need to add
explicit type casts.
Character: 8

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bartosz Dmytrak 2012-12-10 11:59:06 Re: function to_char(unknown, unknown) is not unique
Previous Message Christian Hammers 2012-11-28 17:59:42 Re: Nested composite types again