Re: sort / limit / range problem

> Hi folks,
>
> I've got a glossary table that I'm trying to render to HTML.
> However, I've got a problem when using order by and limit. Below
> is an example of a psql session showing my problem. Anyone got any
> reasons why the last select misses 'Driver'?
>

Everything is ok. Without order by, limit has undeterminated result. It is
described in Postgresql documentation.

Try this:

select glterm from glossary where glterm > 'Driving Wheels'
order by glterm limit 1

select glterm from glossary where glterm > 'Draw Bar'
order by glterm limit 1

Regards,
Tomasz Myrta