| From: | Neil Conway <nconway(at)klamath(dot)dyndns(dot)org> |
|---|---|
| To: | Konrad Scherer <kscherer(at)magma(dot)ca> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Wierdness using SUM to add results of custom C |
| Date: | 2002-02-23 04:36:39 |
| Message-ID: | 1014438999.349.9.camel@jiro |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 2002-02-22 at 21:07, Konrad Scherer wrote:
> The C function returns the correct result all the time but the sum
> returns the wrong result all the time. It mostly returns 23, but it
> returned 24 once!
Can you reproduce the results? You said it returned incorrect data once
-- has it only happened a single time, or does it happen on some regular
basis?
Are you sure that the C function always returns the right results? IMHO
the most likely culprit is a bug in your C function. You might want to
run postgres under gdb (compile with debugging; start up a single
'postgres' process in interactive mode w/o postmaster), and step through
the query to see where the bug comes from.
Cheers,
Neil
--
Neil Conway <neilconway(at)rogers(dot)com>
PGP Key ID: DB3C29FC
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lamar Owen | 2002-02-23 05:04:17 | Re: Cannot restart the postmaster |
| Previous Message | Justin Clift | 2002-02-23 03:31:53 | Re: game db |