sort / limit / range problem
От | Gary Stainburn |
---|---|
Тема | sort / limit / range problem |
Дата | |
Msg-id | 200303051437.47161.gary.stainburn@ringways.co.uk обсуждение исходный текст |
Ответы |
Re: sort / limit / range problem
Re: sort / limit / range problem |
Список | pgsql-sql |
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 ----------------DampersDartDetonatorsDisposalDomeDraw BarDriverDriving WheelsDuty 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 nullgldesc | 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
В списке pgsql-sql по дате отправления: