2011/1/9 Robert Haas <robertmhaas@gmail.com>:
> Oops. I misread your query. I thought the duplicates were because
> you were feeding pg_describe_object the same classoid, objoid,
> objsubid pair more than once, but I see now that's not the case (UNION
> != UNION ALL).
Ah, I see, yes, the query should actually be UNION, it would produce
the same result, but perhaps it would be a bit faster.
--
Best regards,
Joel Jacobson
Glue Finance