Re: problem with float8 input format

From: Louis-David Mitterrand <cunctator(at)apartia(dot)ch>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: problem with float8 input format
Date: 2000-08-11 20:07:39
Message-ID: 20000811220739.A3174@styx
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Fri, Aug 11, 2000 at 11:42:06AM -0400, Tom Lane wrote:
> Louis-David Mitterrand <cunctator(at)apartia(dot)ch> writes:
> > Strangely engough the function call works fine when called from psql but
> > fails (but not always!) from a C trigger.
>
> May we see the C trigger? I'm suspicious it's doing something wrong...
>

Please find the trigger attached to this message as well as the .sql
file containing the full DB schema including the functions. Here is a
typicall log entry of the error:

000811.18:02:03.555 [1673] query:
SELECT incr(max_price($1),0.05)

000811.18:02:03.556 [1673] ERROR: Bad float8 input format '0.05'

Thanks for your help,

--
Louis-David Mitterrand - ldm(at)apartia(dot)org - http://www.apartia.org

Slight disorientation after prolonged system
uptime is normal for new Linux users. Please do
not adjust your browser.

Attachment Content-Type Size
bid_control.c text/x-csrc 14.7 KB
bid_control.h text/x-chdr 927 bytes

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ned Lilly 2000-08-11 20:55:32 tools and apps for PostgreSQL
Previous Message Dan Moschuk 2000-08-11 18:55:39 Re: Postgres problems with large databases.

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Selle 2000-08-11 20:29:21 Returning null from Userdefined C function
Previous Message G. Anthony Reina 2000-08-11 16:19:42 Re: Input strings > 16 K?