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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-jdbc by date

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