Re: display query results
PJ <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.php |
|---|---|
| Message-ID | <[email protected]> |
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") -- Sent via pgsql-php mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-php