Strange change in my where clause?

Поиск
Список
Период
Сортировка
От Bjørn T Johansen
Тема Strange change in my where clause?
Дата
Msg-id 41B455F3.5040502@havleik.no
обсуждение исходный текст
Ответы Re: Strange change in my where clause?
Список pgsql-jdbc
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


Why? The order get messed up....



Regards,


BTJ


--
-----------------------------------------------------------------------------------------------
Bjørn T Johansen

btj@havleik.no
-----------------------------------------------------------------------------------------------
Someone wrote:
"I understand that if you play a Windows CD backwards you hear strange Satanic messages"
To which someone replied:
"It's even worse than that; play it forwards and it installs Windows"
-----------------------------------------------------------------------------------------------

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Nicolas Modrzyk
Дата:
Сообщение: Re: Question reminder
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: Strange change in my where clause?