Re: [despammed] SQL error: function round(double precision, integer) does not exist

From: Andreas Kretschmer <akretschmer(at)despammed(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: [despammed] SQL error: function round(double precision, integer) does not exist
Date: 2005-02-28 09:12:53
Message-ID: 20050228091253.GB32432@webserv.wug-glas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

am 27.02.2005, um 15:26:07 -0800 mailte TJ O'Donnell folgendes:
> 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
> psa,tpsa(smiles) as ctpsa,tpsa
> from structure,tpsa
> where id < 237610
> and oe_count_matches(smiles,smarts) > 0

try ... round((parameter*oe_count_matches(smiles,smarts))::numeric,2)

Regards, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2005-02-28 09:34:19 Re: Postgres 8 - problem: invalid input syntax for integer
Previous Message Richard Huxton 2005-02-28 09:12:09 Re: SQL error: function round(double precision, integer) does