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 = bases.base::text inner join alarm_history on charge.charge = alarm_history.charge or ( alarm_history.alarm_date > charge.fire_date and ( alarm_history.alarm_date < charge.cold_date or charge.cold_date is null ) and device = 'Global') where charge.charge = 64489 This query returns 9 records. For all of them, alarm_history.area is 'Anneal' and bases.area is 'Anneal'. Yet, the column for the equality test is always "f" and the column for the inequality test is always "t"!
The alarm_history table definition begins with: CREATE TABLE alarm_history ( alarm_pkey bigserial NOT NULL, area character varying(32), -- shop area and the bases table definition has: CREATE TABLE bases ( area character varying(32) NOT NULL DEFAULT 'All'::character varying, I have no idea why these two look to be different. I've tried appending an exclamation point to both of them to check for extra spaces at the end. There aren't any. I've tried casting them both to text and to character varying(32), but I got the same results. I'm running PostgreSQL 8.4 on WinXP Pro. I get the same results on a customer's machine running a 64-bit Windows OS, using an identical database. Can anyone explain this, please? RobR
