CAST from VARCHAR to INT
От | Luke Pascoe |
---|---|
Тема | CAST from VARCHAR to INT |
Дата | |
Msg-id | 01df01c2c354$2bac5a60$3200000a@K2 обсуждение исходный текст |
Ответы |
Re: CAST from VARCHAR to INT
Re: CAST from VARCHAR to INT Re: CAST from VARCHAR to INT |
Список | pgsql-sql |
(Postgres 7.2.1) I screwed up when I was designing a table a while back and made a column a VARCHAR that referenced (and should have been) an INT. Now I'm trying to correct my mistake, I've created a new table and I'm trying to INSERT INTO...SELECT the data into it, but it's complaining that it can't stick a VARCHAR into an INT. All the values in the column are valid integers (the foreign key sees to that) but even a CAST won't do it. How can I force it to copy/change the values? ======================================== Luke Pascoe Senior Developer / Systems administrator KMG (NZ) Limited. http://www.kmg.co.nz Mobile: (021) 303019 Email: luke.p@kmg.co.nz ========================================
В списке pgsql-sql по дате отправления: