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

Re: Strange change in my where clause?

From: Bjørn T Johansen <btj(at)havleik(dot)no>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Strange change in my where clause?
Date: 2004-12-06 13:05:55
Message-ID: 41B45933.4070809@havleik.no (view raw or flat)
Thread:
Lists: pgsql-jdbc
Well, it may be my report tool that is changing the sql statement; I am just trying to 
figure out which one does the change...

BTJ

Kris Jurka wrote:
> 
> On Mon, 6 Dec 2004, [ISO-8859-1] Bjørn T Johansen wrote:
> 
> 
>>I have a select where I end like this:
>>
>>...where week = 40 and year = 2004 order by trykkedato, presseID, godeaviser
>>
>>but the statement logged by the server is
>>
>>...where week = 40 and year = 2004 order by 1,3,20
>>
> 
> 
> I find this a little hard to believe.  What logging option are you using?  
> It certainly comes out as expected here with log_statement.
> 
> Kris Jurka
> 

In response to

pgsql-jdbc by date

Next:From: Andrew MDate: 2004-12-06 13:07:27
Subject: Re: SSL confirmation - No trusted certificate found
Previous:From: Kris JurkaDate: 2004-12-06 13:01:28
Subject: Re: Strange change in my where clause?

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