Re: BUG #1494: psql \df to_char

Ludwig Lim wrote:
>
> The following bug has been logged online:
>
> Bug reference:      1494
> Logged by:          Ludwig Lim
> Email address:      ludz_lim@yahoo.com
> PostgreSQL version: 8.0.1
> Operating system:   Linux
> Description:        psql \df to_char
> Details:
>
> Hi:
>
>   I notice that when I type \df to_char in psql prompt the following does
> not appear as one of the possible arguments of to_char:
>
>      time without time zone,text
>
> However, the following select statement works:
>
>    SELECT to_char(current_time :: 'time without time zone', 'ss');
>
>    Is this a bug?
>
> Version of PostgreSQL:
>    PostgreSQL 8.0.1 on i686-pc-linux-gnu compiled by GCC 2.96

Uh, I see:

    test=> \df to_char
                                  List of functions
       Schema   |  Name   | Result data type |        Argument data types
    ------------+---------+------------------+-----------------------------------
     ...
     pg_catalog | to_char | text             | timestamp without time zone, text

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073