Postgres Pro
Downloads
Home   >   mailing lists

Re: [despammed] SQL error: function round(double precision, integer) does not exist - Mailing list pgsql-sql

From Andreas Kretschmer
Subject Re: [despammed] SQL error: function round(double precision, integer) does not exist
Date
Msg-id 20050228091253.GB32432@webserv.wug-glas.de
Whole thread Raw
In response to SQL error: function round(double precision, integer) does not exist  (TJ O'Donnell <tjo@acm.org>)
List pgsql-sql
Tree view 
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    ===

pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Postgres 8 - problem: invalid input syntax for integer
Next
From: Richard Huxton
Date:
Subject: Re: SQL error: function round(double precision, integer) does