Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group