Content-Type: text/plain;
  charset="us-ascii"
From: Gary Stainburn <gary.stainburn@ringways.co.uk>
Organization: Ringways Garages Ltd
To: pgsql-sql@postgresql.org
Subject: sort / limit / range problem
Date: Wed, 5 Mar 2003 14:37:47 +0000
User-Agent: KMail/1.4.3
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Message-Id: <200303051437.47161.gary.stainburn@ringways.co.uk>

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'?

nymr=# select glterm from glossary where glterm like 'D%' order by glterm;
     glterm
----------------
 Dampers
 Dart
 Detonators
 Disposal
 Dome
 Draw Bar
 Driver
 Driving Wheels
 Duty Fitter
(9 rows)

nymr=# select glterm from glossary where glterm > 'Driving Wheels' limit 1;
   glterm
-------------
 Duty Fitter
(1 row)

nymr=# select glterm from glossary where glterm > 'Draw Bar' limit 1;
     glterm
----------------
 Driving Wheels
(1 row)

nymr=# \d glossary
                                    Table "glossary"
 Attribute |         Type          |                      Modifier
-----------+-----------------------+-----------------------------------------------------
 glid      | integer               | not null default 
nextval('glossary_glid_seq'::text)
 glterm    | character varying(30) | not null
 gldesc    | text                  |
Indices: glossary_pkey,
         glossary_term_index

nymr=#

-- 
Gary Stainburn
 
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000