From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | sconeek(at)gmail(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Java, postgres and jasper help |
Date: | 2005-11-22 15:20:32 |
Message-ID: | 43833740.8090701@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
sconeek(at)gmail(dot)com wrote:
> hi all,
>
> i am trying to fix this bug within my program. its a java, postgres and
> jasper based program which generates charts. now i am generating a
> chart which does not show any 0 data points if they exist, only
> non-zero ones. obviously i am trying to do everything in just one sql
> query, but i am not sure if its possible or not. i also need to
> generate a temporary table and then delete it.
>
> I have broken the tasks into,
> 1. create a temp table
> 2. create records for 0 data points
> 3. update with non 0 records
> 4. delete temp table.
>
> now this is what i have and i would appreciate all help with fixing
> this,
Two points:
1. If you quote your column-names when you create them, quote when you
access them too.
2. You don't actually say what the problem is.
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2005-11-22 15:22:36 | Re: problem with GRANT postgres 8.0.4 |
Previous Message | Adrian Klaver | 2005-11-22 15:04:16 | Re: Best way to represent values. |