Re: function to_char(unknown, unknown) is not unique

From: Alex Bozhenko <alexbozhenko(at)gmail(dot)com>
To: Bartosz Dmytrak <bdmytrak(at)gmail(dot)com>
Cc: PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: function to_char(unknown, unknown) is not unique
Date: 2012-12-10 12:10:49
Message-ID: CAC-xioJAoc9tMRGdSCS4u-Q-82HVyyrgBN=zE=PGu6dkQ4fMKw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Ok, i have understand.

Select from table works because of type date of column.

Thanks!

2012/12/10 Bartosz Dmytrak <bdmytrak(at)gmail(dot)com>

> hi,
> try SELECT to_char(null::date, 'DD.MM.YYYY')::text or SELECT
> to_char(null::timestamp, 'DD.MM.YYYY')::text
>
> should work.
> It is not possible to guess type of null without explicit cast.
>
> Regards,
> Bartek
>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Manning John 2012-12-14 16:27:27 Calling PQconnectdb from an .so on a hardened SLES 11
Previous Message Bartosz Dmytrak 2012-12-10 11:59:06 Re: function to_char(unknown, unknown) is not unique