Re: EXTERN JOIN with WHEN query - Mailing list pgsql-general

On Thu, 5 Jun 2003 16:56:54 +0200, javier garcia - CEBAS
<rn001@cebas.csic.es> wrote:
>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"

The keyword is "WHERE".  And I guess the WHERE clause has to be

    WHERE fechas.fecha >= (SELECT min(fecha) FROM precal41)

or, if there is an index on precal41.fecha, more efficiently but
non-standard

    WHERE fechas.fecha >= (SELECT fecha
                             FROM precal41 ORDER BY fecha LIMIT 1)

HTH.
Servus
 Manfred