Re: [HACKERS] varchar function
Thomas Lockhart <lockhart@alumni.caltech.edu>
From: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
To: "jose' soares" <sferac@bo.nettuno.it>
Cc: pgsql-hackers@postgreSQL.org
Date: 1999-02-18T03:16:57Z
Lists: 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