News for hackers. Stuff that matters.
Re:Cost of a Join by davidgould on Wednesday August 15, 2018 @05:30AM (#17764730)
It is logically a join on oid to the pg_enum table. The implementation takes a few shortcuts but really the basic join machinery has been hand polished for decades so that doesn't make much difference.

Because enums are stored in pg_enum which is just a table like the rest of the catalogs you can join to it with your own SQL queries. If you are very bold and a bit bad superuser you can even update them.

There are no comments on this comment yet.