Re: [Refdb-users] One last question

[Markus H. <mar...@mh...>]

Rich Shepard writes:
 >    I just checked again with both joe and emacs. When I press ctrl-e (to move
 > to the end of the line), the cursor immediately follows the final 'e' in both
 > cases. I cannot find a trailing space. In both editors, if I press 'ctrl-d'
 > to delete the character to the right of the point (in both editors), the
 > newline is removed. I cannot find a trailing space after either of them. I
 > _thought_ that I had checked for that before asking for help.
 > 

No matter what I do, the space is there. I've checked the SQL dump you
sent me off-list. The "shortnose" keyword has the ID 222, the
"shortnose " (note the trailing space) has the ID 308. I managed to
create a scirefs database in PostgreSQL with exactly these data. I ran
the following query:

refdbc: getref -t ris :KW:~shortnose -o rich.ris
932 byte written to /usr/home/markus/rich.ris
999:3 retrieved:0 failed

rich.ris looks like this:


TY  - RPRT
ID  - desj00
AU  - Desjardins,M.
AU  - Markle,D.F.
KW  - fish
KW  - lakes
KW  - Klamath Basin
KW  - distribution
KW  - shortnose
KW  - Lost River
KW  - sucker
RP  - NOT IN FILE
BT  - Distribution and biology of suckers in Lower Klamath Reservoirs
CY  - Portland, Oregon
PY  - 2000///
ER  - 

TY  - RPRT
ID  - coen01
AU  - Coen,M.A.
AU  - Shively,R.
KW  - fish
KW  - Oregon
KW  - lakes
KW  - spawning
KW  - Klamath Basin
KW  - shortnose
KW  - Lost River
KW  - sucker
RP  - NOT IN FILE
BT  - Sampling of suckers in Upper Klamath Lake, Oregon to identify shoreline spawning sites
PY  - 2001///
ER  - 

TY  - RPRT
ID  - cunn01
AU  - Cunningham,M.E.
AU  - Shively,R.
TI  - Monitoring report of Lost River and Shortnose suckers in the lower Williamson River, Oregon
KW  - fish
KW  - Oregon
KW  - monitoring
KW  - rivers
KW  - Klamath Basin
KW  - Lost River
KW  - sucker
KW  - shortnose 
RP  - NOT IN FILE
PY  - 2001///
ER  - 

The first two entries (desj00 and coen01) use the spaceless shortnose,
whereas cunn01 uses the shortnose with a trailing space. While you ran
your tests, you probably queried for :KW:=shortnose (without a
space). This will return only the first two entries that match
exactly. It will not return the third entry as the keyword differs by
one space. In order to get that one too, you need to query for
:KW:~shortnose or something similar. I reckon you added the "shortnose
" accidentally and never found that entry again.

This solves one part of the puzzle. I'm still at a loss why the
datasets are returned without empty lines inbetween. As you can see in
the output above, your data work just fine on my system.

regards,
Markus

-- 
Markus Hoenicka
mar...@ca...
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de