On Sat, Jan 8, 2011 at 8:02 PM, Joel Jacobson <[email protected]> wrote: > 2011/1/9 Robert Haas <[email protected]>: >> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
