Re: select issue with order v8.1

Terry <td3201(at)gmail(dot)com> writes:
> 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?

Hrm, fix the application?

You might be able to make a go out of something along the lines of

select ev_id,... from (select * from clients_event_log limit 100) as ss;

which would admit an ORDER BY on the end.

BTW, in most cases it doesn't make any sense to have a LIMIT without an
ORDER BY inside the subselect --- unless you really don't care which 100
rows you get.

regards, tom lane