Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 09AA937D2DD
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon,  6 Oct 2008 11:13:29 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 95747-01-7 for
	<pgsql-admin-postgresql.org@postgresql.org>;
	Mon,  6 Oct 2008 11:13:23 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by postgresql.org (Postfix) with ESMTP id B024837BA2D
	for <pgsql-admin@postgresql.org>; Mon,  6 Oct 2008 11:13:03 -0300 (ADT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m96ECGEn003156;
	Mon, 6 Oct 2008 10:12:16 -0400 (EDT)
To: Guy Deleeuw <G.De_Leeuw@eurofer.be>
cc: pgsql-admin@postgresql.org
Subject: Re: sql command strange behaviour 
In-reply-to: <48E9CD06.4030307@eurofer.be> 
References: <864f9e230810040547j62e8d50cs6d30932d9f4c1f0@mail.gmail.com>
	<48E774A7.2020409@eurofer.be>
	<864f9e230810040653o7ef5a1c5l20ea3946545dc323@mail.gmail.com>
	<48E9CD06.4030307@eurofer.be>
Comments: In-reply-to Guy Deleeuw <G.De_Leeuw@eurofer.be>
	message dated "Mon, 06 Oct 2008 10:32:06 +0200"
Date: Mon, 06 Oct 2008 10:12:16 -0400
Message-ID: <3155.1223302336@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200810/27
X-Sequence-Number: 30483

Guy Deleeuw <G.De_Leeuw@eurofer.be> writes:
> Now I execute this query that request one column more, the "ind" field., 
> the return of this query is bad.

You didn't say what you think is bad about it ... but in any case I'll
bet that this bit isn't doing what you want:

	... AND (ind=ind) ...

As-is it's useless.  You probably need to table-qualify one or both
names.

			regards, tom lane