Message-ID: <3A99D769.94EF54B6@oldbs.com>
Date: Sun, 25 Feb 2001 23:11:22 -0500
From: Ken Kline <ken@oldbs.com>
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: conversion
References: <3A99C025.BBF58939@oldbs.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

follow up....
actually the destination column is defined
as a numeric(4)

the following are the statements again with there error messages:

SELECT pseason, to_number(pyear,'9999') from temp;
ERROR: Bad numeric input format  '  '

 SELECT pyear::int from temp;
ERROR: Cannot cast type 'varchar' to 'int4'


Ken Kline wrote:

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