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

From Bruno Wolff III
Subject Re: EXTERN JOIN with WHEN query
Date
Msg-id 20030606122153.GB30097@wolff.to
Whole thread Raw
In response to EXTERN JOIN with WHEN query  (javier garcia - CEBAS <rn001@cebas.csic.es>)
List pgsql-general
On Thu, Jun 05, 2003 at 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"
>
> Could you help me with this query?

The keyword should be "WHERE" instead of "WHEN".

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Create index on the year of a date column
Next
From: kdebisschop@alert.infoplease.com
Date:
Subject: Re: Nulls get converted to 0 problem