Re: SQL error: function round(double precision, integer) does

From: Richard Huxton <dev(at)archonet(dot)com>
To: tjo(at)acm(dot)org
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: SQL error: function round(double precision, integer) does
Date: 2005-02-28 09:12:09
Message-ID: 4222E069.9060108@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Kretschmer 2005-02-28 09:12:53 Re: [despammed] SQL error: function round(double precision, integer) does not exist
Previous Message Igor Kryltsov 2005-02-28 05:46:55 Postgresql FK to MS SQL triggers