Re: using WHERE and AND in SELECT

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jean-Yves MARTIN <Jean-Yves(dot)Martin(at)ec-nantes(dot)fr>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: using WHERE and AND in SELECT
Date: 2017-06-08 14:10:39
Message-ID: 11788.1496931039@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Jean-Yves MARTIN <Jean-Yves(dot)Martin(at)ec-nantes(dot)fr> writes:
> We had an issue when writing a SELECT request : we write:
> select personne_id from personne inner join conducteur on (conducteur.personne_id=personne.personne_id) and personne.personne_id<20

There's no requirement for parentheses around the JOIN condition,
so that's perfectly legal.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2017-06-08 17:00:26 Re: [PATCH] Fixed malformed error message on malformed SCRAM message.
Previous Message K S, Sandhya (Nokia - IN/Bangalore) 2017-06-08 12:25:14 Re: [BUGS] Crash observed during the start of the Postgres process