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