Re: sql command strange behaviour

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Guy Deleeuw <G(dot)De_Leeuw(at)eurofer(dot)be>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: sql command strange behaviour
Date: 2008-10-06 14:12:16
Message-ID: 3155.1223302336@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Guy Deleeuw <G(dot)De_Leeuw(at)eurofer(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Rich 2008-10-06 15:00:55 Re: Postgres database as a client/server architecture
Previous Message Scott Marlowe 2008-10-06 14:08:23 Re: Postgres database as a client/server architecture