| 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
| 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 |