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 f1Q2VFx83173 for ; Sun, 25 Feb 2001 21:31:16 -0500 (EST) (envelope-from ken@oldbs.com) Received: (cpmta 12711 invoked from network); 25 Feb 2001 18:31:10 -0800 Received: from unknown (HELO oldbs.com) (216.91.245.19) by smtp.oldbs.com (209.228.12.81) with SMTP; 25 Feb 2001 18:31:10 -0800 X-Sent: 26 Feb 2001 02:31:10 GMT Message-ID: <3A99C025.BBF58939@oldbs.com> Date: Sun, 25 Feb 2001 21:32:06 -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: pgsql-sql@postgresql.org Subject: conversion Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200102/393 X-Sequence-Number: 1598 Hello, another brain twister, at least for me... i have a table of varchar and one of the values I want to insert into another table, one of the columns is defined as INTEGER in destination table, column... and none of these statements seem to work INSERT INTO pledge_classes (semester, year) SELECT pseason, to_number('pyear','9999') from temp; INSERT INTO pledge_classes (semester, year) SELECT pseason, pyear::integer from temp; INSERT INTO pledge_classes (semester, year) SELECT pseason, pyear::numeric(4) from temp;