Re: left joins

From: Ragnar Hafstað <gnari(at)simnet(dot)is>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: left joins
Date: 2005-07-07 00:19:17
Message-ID: 1120695557.14290.22.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tony Wasson 2005-07-07 01:11:32 Re: left joins
Previous Message Tom Lane 2005-07-06 19:55:59 Re: Prepare plan in plpgsql