How to round a double8 data type in sql?

From: Chuck Roberts <croberts(at)gilsongraphics(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: How to round a double8 data type in sql?
Date: 2015-02-04 15:00:58
Message-ID: a66f47935d0a8364587b80cc083eb8d6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message David G Johnston 2015-02-04 16:07:55 Re: How to round a double8 data type in sql?
Previous Message Tom Lane 2015-02-02 17:17:18 Re: Do not output header line in psql