> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
