Re: [SQL] datatype conversion on postgresql 7.4.1

2005-05-24 Thread Richard Huxton
Timo Roessner wrote: and if i try something like: alter table fragment alter column x type numeric(15,2) i get an syntax error, so this seems to be no feature in 7.4.1 (didnt find anything like that in the docs too) what can i do to solve this? there must be some way in postgresql 7.4.1

[SQL] datatype conversion on postgresql 7.4.1

2005-05-22 Thread Timo Roessner
hi everybody, i got the following problem: i have a database running on a postgresqlserver version 7.4.1, in the database is a table with 4 columns containing float-numbers. what i want to do now is, to convert the type of those columns from float to numeric, because i want to limit the posi