Re: Syntax Error

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: Marcel Boscher <mboscher(at)emedia-office(dot)de>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Syntax Error
Date: 2004-08-10 13:12:27
Message-ID: 1092143546.11679.2.camel@linda
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Tue, 2004-08-10 at 13:44, Marcel Boscher wrote:
> Hey there,
>
> ERROR: function round(double precision, integer, integer) does not exist
> Any suggestions

No such function is defined.

According to the manual there are:

round(double precision)
round(numeric)
round(numeric, integer)

The second parameter of the last one specifies the number of decimal
places.

--
Oliver Elphick olly(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
"Be still before the LORD and wait patiently for him;
do not fret when men succeed in their ways, when they
carry out their wicked schemes."
Psalms 37:7

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2004-08-10 14:45:58 Re: SOUNDEX
Previous Message Marcel Boscher 2004-08-10 12:44:52 Syntax Error