| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | Christine Penner <christine(at)ingenioussoftware(dot)com> |
| Cc: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, jd(at)commandprompt(dot)com, Richard Huxton <dev(at)archonet(dot)com>, Bill Moran <wmoran(at)potentialtech(dot)com>, Postgres-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Cast char to number |
| Date: | 2010-02-24 21:47:00 |
| Message-ID: | 4B859E54.9090502@iol.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 24/02/2010 21:42, Christine Penner wrote:
> This is what I did.
>
> set all blank columns to '0' because they were causing errors.
> alter table T alter column a type integer using a::integer
>
> That worked perfectly.
Glad you got sorted.
Bill's advice upthread is worth taking on board - if you're in a
position to do so, make sure that numbers are stored as numbers rather
than text, and you'll save yourself all sorts of wacky grief.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2010-02-24 21:47:01 | Re: Curious plperl behavior |
| Previous Message | Christine Penner | 2010-02-24 21:42:29 | Re: Cast char to number |