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

Re: Strange change in my where clause?

From: Kris Jurka <books(at)ejurka(dot)com>
To: Bjørn T Johansen <btj(at)havleik(dot)no>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Strange change in my where clause?
Date: 2004-12-06 13:01:28
Message-ID: Pine.BSO.4.56.0412060800450.16153@leary.csoft.net (view raw or flat)
Thread:
Lists: 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


In response to

Responses

pgsql-jdbc by date

Next:From: Bjørn T JohansenDate: 2004-12-06 13:05:55
Subject: Re: Strange change in my where clause?
Previous:From: Kris JurkaDate: 2004-12-06 12:57:31
Subject: Re: SSL confirmation - No trusted certificate found

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