cast numeric to char

From: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: cast numeric to char
Date: 2002-10-28 14:52:42
Message-ID: 73309C2FDD95D11192E60008C7B1D5BB04C74113@snt452.corp.bcbsm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Howdy:

Running PostgreSQL 7.2.1 -

I'm trying to cast a numeric field to character, but I
am getting errors saying that it can not be done.

[snip errors]

testdb=> select lpad(i_pd::char,7,'0') from t_table limit 1;
ERROR: Cannot cast type 'numeric' to 'character'

[/snip error]

Is it that I *can not* cast numeric into character value or
or do I need some new methodology of doing this?

Thanks!

-X

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Darren Ferguson 2002-10-28 14:56:05 Re: cast numeric to char
Previous Message Dorward Villaruz 2002-10-28 14:42:14 EUC_JP multibyte support