Postgres Pro
Downloads
Home   >   mailing lists

[BUGS] using WHERE and AND in SELECT - Mailing list pgsql-bugs

From Jean-Yves MARTIN
Subject [BUGS] using WHERE and AND in SELECT
Date
Msg-id 27B4C0D6-6744-4F25-9DA5-2BAE3AF8B6A3@ec-nantes.fr
Whole thread Raw
Responses Re: [BUGS] using WHERE and AND in SELECT  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view
Hi,

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

instead of:
select personne_id from personne inner join conducteur on (conducteur.personne_id=personne.personne_id) where personne.personne_id<20

and there is no syntax error. both give the same result.

is it a bug in the SQL grammar or is it a usable syntax?

regards,

JY Martin.


Logo CNJean-Yves MARTIN
Responsable Option Informatique
----
Dept Informatique et Mathématiques
Centrale Nantes
1 rue de la Noë
44321 Nantes, cedex 3
France
----
Tel: +33 2 40 37 25 98
Mail: Jean-Yves.Martin@ec-nantes.fr


pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [BUGS] [PATCH] Fixed malformed error message on malformed SCRAM message.
Next
From: "K S, Sandhya (Nokia - IN/Bangalore)"
Date:
Subject: Re: [BUGS] Crash observed during the start of the Postgres process