On Jun 27, 2007, at 10:36 , Carol Cheung wrote:
> My question is: Is it possible to alter the 'some_int' column
> directly without having to create a temporary 'some_time' holding
> column?
Are you trying to alter the table to replace your some_int column
with a some_time column? I believe you can do this in two steps.
SELECT *
FROM some_data;
some_int
----------
12
345
1622
1
(4 rows)
ALTER TABLE some_data
ALTER some_int TYPE TIME WITHOUT TIME ZONE
USING CAST(to_char(some_int, 'FM99909:99') AS TIME WITHOUT
TIME ZONE);
ALTER TABLE some_data
RENAME some_int TO some_time;
SELECT *
FROM some_data;
some_time
-----------
00:12:00
03:45:00
16:22:00
00:01:00
(4 rows)
Hope this helps.
Michael Glaesemann
grzm seespotcode net