Re: [HACKERS] varchar function - Mailing list pgsql-hackers

From Thomas G. Lockhart
Subject Re: [HACKERS] varchar function
Date
Msg-id 36CB8629.8404FAFC@alumni.caltech.edu
Whole thread Raw
In response to varchar function  ("jose' soares" <sferac@bo.nettuno.it>)
List pgsql-hackers
> I'm trying to create a varchar(float8) to cast float to varchar but I
> can't create it.
> --Any ideas ?

>From the current development tree (I'm pretty sure; may not have
committed everything yet):

postgres=> select varchar('123'::float8);
ERROR:  parser: parse error at or near "'"
postgres=> select varchar(float8 '123');
ERROR:  parser: parse error at or near "float8"
postgres=> select (float8 '123')::varchar;
?column?
--------    123
(1 row)

It seems that there are some problems with calls to functions named
varchar().
                        - Tom


pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: [HACKERS] 8K block limit
Next
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] 8K block limit