Received: from c014.sfo.cp.net (c014-h017.c014.sfo.cp.net [209.228.12.81]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1QIB8x13860 for ; Mon, 26 Feb 2001 13:11:08 -0500 (EST) (envelope-from ken@oldbs.com) Received: (cpmta 9775 invoked from network); 26 Feb 2001 08:46:44 -0800 Received: from unknown (HELO oldbs.com) (216.91.245.19) by smtp.oldbs.com (209.228.12.81) with SMTP; 26 Feb 2001 08:46:44 -0800 X-Sent: 26 Feb 2001 16:46:44 GMT Message-ID: <3A9A8879.1DF0CE96@oldbs.com> Date: Mon, 26 Feb 2001 11:46:49 -0500 From: Ken Kline X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.16-22min_for_stan i586) X-Accept-Language: en MIME-Version: 1.0 To: Christopher Sawtell CC: pgsql-sql@postgresql.org Subject: Re: conversion References: <3A99C025.BBF58939@oldbs.com> <3A99D769.94EF54B6@oldbs.com> <01022619511701.09893@berty> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200102/405 X-Sequence-Number: 1610 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 > <<--