Is it possible at all to do this without any joins or subselect?
I don't think so. You could always hide them in a view... ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq