sconeek@gmail.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