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(at)yahoo(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073