Stefan Schwarzer <stefan.schwarzer@grid.unep.ch> writes: > But now, I have another problem in this context. If I use text in the > SELECT statement (so, that the final output gives me the name of the > selected variables, plus the year and the value) than I get this > error message: ERROR: failed to find conversion function from > "unknown" to text [squint...] Try casting those literals to text explicitly, ie SELECT 'pop_density'::text AS name. There's some code in there that makes this work for simple UNION cases, but maybe not so much for select with a left join and order by and limit inside a union :-( regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly