From: Martin Knipper <knipper@mk-os.de>
To: pgsql-sql@postgresql.org
Subject: Re: typecasting numeric(18,4) to varchar/text
Date: Tue, 04 May 2004 17:08:53 +0200
Message-ID: <4097B205.2040402@mk-os.de> (raw)
In-Reply-To: <20040504143745.GA10467@phlogiston.dyndns.org>
References: <63340-22004524133531385@M2W046.mail2web.com>
<20040504143745.GA10467@phlogiston.dyndns.org>
Am 04.05.2004 16:37 schrieb Andrew Sullivan:
> On Tue, May 04, 2004 at 09:35:31AM -0400, ashok@kalculate.com wrote:
>
>>create table a (a numeric(18,4));
>>create table b (b varchar(25));
>>insert into a values(12000.43);
>>insert into b select (a.a)::varchar;
>
>
> Which version is that? Here's my session:
>
> andrewtest=# create table a (a numeric(18,4));
> CREATE TABLE
> andrewtest=# create table b (b varchar(25));
> CREATE TABLE
> andrewtest=# insert into a values(12000.43);
> INSERT 17168 1
> andrewtest=# insert into b select (a.a)::varchar;
> INSERT 17169 1
>
> That's on 7.4.2. You might want to try casting to text first.
>
Yes, it also works for me with Version 7.4.2.
I found an older postgres DB with Version 7.2 and I get the same
error as ashok
demo=# select a::varchar from a;
ERROR: Cannot cast type 'numeric' to 'character varying'
demo=# select a::text from a;
ERROR: Cannot cast type 'numeric' to 'text'
demo=# select '\'' || a || '\'' from a;;
ERROR: Unable to identify an operator '||' for types 'unknown'
and 'numeric'
You will have to retype this query using an explicit cast
Greetings,
Martin
--
Martin Knipper
www : http://www.mk-os.de
Mail : knipper@mk-os.de
Random Signature:
-----------------
while( !asleep() ) sheep++;
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: knipper@mk-os.de
Subject: Re: typecasting numeric(18,4) to varchar/text
In-Reply-To: <4097B205.2040402@mk-os.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox