select issue with order v8.1

Поиск
Список
Период
Сортировка
От Terry
Тема select issue with order v8.1
Дата
Msg-id 8ee061011002241950ibf1316fw681a38b5ff404e@mail.gmail.com
обсуждение исходный текст
Ответы Re: select issue with order v8.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: select issue with order v8.1  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-general
Hello,

I have an application that is doing something stupid in that it is
tacking on its own order clause at the end of the statement I am
providing.

For example, I am putting this statement in:
select ev_id,type,ev_time,category,error,ev_text,userid,ex_long,client_ex_long,ex_text
from clients_event_log limit 100

It is tacking on ORDER BY ev_id.  The problem is that isn't per the
syntax.  Can anyone think of anything clever to get around this stupid
application doing what it is doing?  For example, anything I can do
beside limit?

I appreciate the thoughts!

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Cast char to number
Следующее
От: Tom Lane
Дата:
Сообщение: Re: select issue with order v8.1