Translating code numbers to item descriptions in PostgreSQL query
You should put all the mapping between itemId values and whatever constant strings in a separate table (2 columns) and do a join with it.
This allows you to update the mapping (by changing the table content) without even changing the query later on.
(and this is not specific to PostgreSQL, will work with any RDBMS)