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