> I want to add x and y. John and Joe do not have a "y" value, so the LEFT > JOIN returns NULL. Likewise Jane does not have a value for "x" so the > LEFT JOIN returns null for her. The "x" and "y" columns are correct, but > I would expect the "total" column to have 24, 232, and 4. myview is a > view that converts id numbers to the actual names. run, project and name > come from myview. Both x and y come from the site table.
> Can anyone tell me why the "total" column is empty? becuase null + <pretty much anything> = null check out COALESCE: http://www.postgresql.org/docs/8.1/interactive/functions-conditional.html#AEN12654 Regards, Richard Broersm Jr. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
