Re: SQL error: function round(double precision, integer) does - Mailing list pgsql-sql

TJ O'Donnell wrote:
> I received the following error when executing a SQL statement:
> 
> SQL error:
> ERROR:  function round(double precision, integer) does not exist
> 
> In statement:
> 
> select id,smiles,smarts,parameter,oe_count_matches(smiles,smarts) as count,
>  round((parameter*oe_count_matches(smiles,smarts)),2) as 

round((...)::numeric, 2)

--  Richard Huxton  Archonet Ltd