Stephan Szabo wrote:
We don't support join conditions like the above at this point. ThePurely out of interest, what does that message mean? Why aren't they supported?
message isn't terribly helpful though.
Fortunately, I think some variant like
select table1.field from table1
union all
select table2.field from table2;
will give you the output you're looking for.
It's exactly what I'm looking for. Thank you and Tom.
Shachar
-- Shachar Shemesh Lingnu Open Source Consulting ltd. http://www.lingnu.com/
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org