Sorry, I made a mistake in my previous letter, the table b looks like this: b) y | z ---------------- 100 (not 1) | 'Hallelujah' NULL | 'Hmm...' Bye, Baldvin ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html