[GENERAL] 'Anneal' 'Anneal'

2010-04-05 Thread Rob Richardson
Greetings! I have the following query: select charge.charge, alarm_history.area || '!', bases.area || '!', alarm_history.area::character varying(32) = bases.area::character varying(32), alarm_history.area bases.area, alarm_history.* from charge JOIN bases ON charge.base::text =

Re: [GENERAL] 'Anneal' 'Anneal'

2010-04-05 Thread Rob Richardson
Thank you. That got it. It gave the expected result of false for the inequality check. I took a second look at the output of the query and saw the extra space in front of 'Anneal' in the alarm_history table's field. RobR -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)