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;