EXTERN JOIN with WHEN query

From: javier garcia - CEBAS <rn001(at)cebas(dot)csic(dot)es>
To: pgsql-sqL <pgsql-sql(at)postgresql(dot)org>
Subject: EXTERN JOIN with WHEN query
Date: 2003-06-05 10:55:14
Message-ID: 200306051042.h55AgCI27558@natura.cebas.csic.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all;
This is a query that I guess is not very dificult, but I'm a newbie;
I've got a lot of tables, each of them with two columns:

SELECT * FROM precal; ->
(date) (real)
fecha | precipitacion
------------+---------------
1996-01-01 | 0.6
1996-02-01 | 0.7
...

But in this table there are some inexistents records (some missing days)
And I would like to create lists with a full list of dates and corresponding
precipitation data, with gaps when the row didn't exist.
So; I've created a table with a complete series of dates from 1950 up to
date, and made the query:

SELECT fechas.fecha,precipitacion FROM fechas LEFT OUTER JOIN precal41 ON
(fechas.fecha = precal41.fecha);

This is perfect. But to make it better, would like to include just the dates
from the first one in the precal table. So, I've tried:

SELECT fechas.fecha,precipitacion FROM fechas LEFT OUTER JOIN precal41 ON
(fechas.fecha = precal41.fecha) WHEN fechas.fecha >= min(precal41.fecha);
With the answer:

ERROR: parser: parse error at or near "WHEN"

Could you help me with this query?

Thanks and regards

Javier

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Achilleus Mantzios 2003-06-05 11:39:33 To ListAdms: Is pgsql-sql operating?
Previous Message David Pradier 2003-06-04 14:59:02 How to make a IN without a table... ?