You were quite right, the problem was a line feed after the word "Alcohol"
Now it works fine.
Thanks, I learned a lot .... :)
Andy Shellam wrote:
Haha, no worries, I've had the same issue before.
It's almost certain that the text in your column does not exactly
match "Alcohol" for one of a few reasons, e.g.
"Alcohol " (right-padding)
" Alcohol" (left-padding)
" Alcohol " (padded both sides)
will not match = 'Alcohol' in the query.
Try trimming the data in that field - from PgAdmin or some other
query tool, run something like:
|UPDATE glossary_item SET "name" = |trim(both ' ' from "name")
