Re: a LEFT JOIN problem

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: a LEFT JOIN problem
Date: 2008-10-27 12:24:34
Message-ID: 20081027122434.GP2459@frubble.xen.chris-lamb.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Clark 2008-10-27 13:19:08 8.3.x log maintenance
Previous Message Sam Mason 2008-10-27 12:16:46 Re: psql screen size