Re: left joins - Mailing list pgsql-sql

From Ragnar Hafstað
Subject Re: left joins
Date
Msg-id 1120695557.14290.22.camel@localhost.localdomain
Whole thread Raw
In response to Re: left joins  ("Nick Stone" <nick@harelane.com>)
Responses Re: left joins
List pgsql-sql
On Wed, 2005-07-06 at 11:33 +0100, Nick Stone wrote:
> I've had exactly yhe same problem - try changing the query to.
> 
> select count(*)
>  from  h left join p using (r,pos) and p.r_order=1
> where h.tn > 20
> and h.tn < 30

really ? is this legal SQL ?
is this a 8.0 feature ?
I get syntax error at or near "and" at character 41

gnari





pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Prepare plan in plpgsql
Next
From: Tony Wasson
Date:
Subject: Re: left joins