Re: Strange change in my where clause? - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Strange change in my where clause?
Date
Msg-id Pine.BSO.4.56.0412060800450.16153@leary.csoft.net
Whole thread Raw
In response to Strange change in my where clause?  (Bjørn T Johansen <btj@havleik.no>)
Responses Re: Strange change in my where clause?  (Bjørn T Johansen <btj@havleik.no>)
List pgsql-jdbc

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


pgsql-jdbc by date:

Previous
From: Bjørn T Johansen
Date:
Subject: Strange change in my where clause?
Next
From: Bjørn T Johansen
Date:
Subject: Re: Strange change in my where clause?