> 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