(damn gmail, sorry about priv mail earlier)
Stephan Szabo <[EMAIL PROTECTED]>: I think putting a test in an ON clause associated with the join (using something like ... left join object_values ov1 ON(ov.obj_id = ov1.obj_id and ov1.att_id=8) rather than where will consider both as part of the join and null extend even if there are obj_id matches if none of those have att_id=8.
Thanks, that worked! 2006/4/28, Tom Lane <[EMAIL PROTECTED]>:
Emils <[EMAIL PROTECTED]> writes: > The table structure is: > object_values > ========== This isn't an outer-join problem, it's a crosstab problem. Try the crosstab functions in contrib/tablefunc.
Thanks, I looked into it, unfortunately I might have to have also a solution for where installing contrib stuff is not possible. Emils ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
