On Sat, Jan 8, 2011 at 8:02 PM, Joel Jacobson <j...@gluefinance.com> wrote: > 2011/1/9 Robert Haas <robertmh...@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.
You did use UNION - I think if you used UNION ALL you'd get spurious results. But maybe I'm still confused. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
