Solved! Was (Return t/f on existence of a join)

[Madison Kelly <linux@xxxxxxxxxxx>]

Thanks to both of you, Erik and Jon!

  I had to tweak your two replies to get what I wanted (all 'foo' rows 
returned, was only getting ones with a match in 'baz'). You two sent me 
on the right path though and I was able to work out the rest using the 
PgSQL docs on 'CASE' and 'JOIN'.

  Here is the working query (where 'bar_id'=2):

SELECT
	CASE z.baz_bar_id
	WHEN 2
		THEN TRUE
		ELSE FALSE
	END AS tf_col,
	f.foo_id
FROM foo f
	LEFT OUTER JOIN baz z
	ON (f.foo_id=z.baz_foo_id)
	LEFT OUTER JOIN bar b
	ON (b.bar_id=z.baz_bar_id)
AND
	b.bar_id=2;

  Thanks kindly to both! I honestly didn't expect to work this out 
before then end of the day. Cool!

Madi

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
      message can get through to the mailing list cleanly