Re: [HACKERS] varchar function

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: "jose' soares" <sferac(at)bo(dot)nettuno(dot)it>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] varchar function
Date: 1999-02-18 03:16:57
Message-ID: 36CB8629.8404FAFC@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Vadim Mikheev 1999-02-18 03:17:01 Re: [HACKERS] 8K block limit
Previous Message Tatsuo Ishii 1999-02-18 03:09:02 Re: [HACKERS] 8K block limit