Re: conversion

here you go, thanks in advance, ken

Table "temp"
Attribute | Type | Modifier
-----------+-------------+----------
pseason | varchar(15) |
pyear | varchar(5) |

adx=# \d pledge+ _classe4s  s
Table "pledge_classes"
Attribute | Type | Modifier
-----------+--------------+------------------------------------------
pc_id | integer | not null default nextval('pc_seq'::text)
semester | varchar(6) |
year | numeric(4,0) |
pc_letter | varchar(20) |
pc_name | varchar(50) |
Index: pc_pk

adx=# \q
bash-2.04$
Script done on Mon Feb 26 11:42:35 2001

Christopher Sawtell wrote:

> On Mon, 26 Feb 2001 17:11, Ken Kline wrote:
> > follow up....
> > actually the destination column is defined
> > as a numeric(4)
>
> Could you to a \d on each of the tables and tell us the results.
>
> [ ... ]
>
> --
> Sincerely etc.,
>
> NAME Christopher Sawtell
> CELL PHONE 021 257 4451
> ICQ UIN 45863470
> EMAIL csawtell @ xtra . co . nz
> CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz
>
> -->> Please refrain from using HTML or WORD attachments in e-mails to me
> <<--