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
> <<--