Postgres 8.4
How do I use round() in sql on a double8 data type? While in an SQL
statement, I can use round just fine on a field that is a type of double.
Ex: Select round(esthours,2) as ehrs from job;
But a different field has a type of double8 and I get an error when I try
to use round on it:
select round(acthours,2) as ahrs from job;
The error is: "No function matches the given name and argument types. You
might need to add explicit type casts."
I searched around on Google but found no help on doing type casts.
Thank you.