Re: a LEFT JOIN problem - Mailing list pgsql-general

From Sam Mason
Subject Re: a LEFT JOIN problem
Date
Msg-id 20081027122434.GP2459@frubble.xen.chris-lamb.co.uk
Whole thread Raw
In response to Re: a LEFT JOIN problem  (Thomas <iamkenzo@gmail.com>)
Responses Re: a LEFT JOIN problem  (Thomas <iamkenzo@gmail.com>)
List pgsql-general
On Mon, Oct 27, 2008 at 10:47:13AM +0100, Thomas wrote:
> Unfortunately, I cannot use >= in the ON clause when making a search
> on a date range.

The right-hand-side of an ON clause is a general expression; you can
include (and I regularly do) arbitrary functions and operators.

I'm probably missing something obvious; but if you included a little
more detail in your message and preferably some context you'd get a more
useful response.


  Sam

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: psql screen size
Next
From: "postgres Emanuel CALVO FRANCO"
Date:
Subject: Re: Replication with slony-I