On Tue, 22 Apr 2008 15:45:39 -0500 "D. Dante Lorenso" <dante@xxxxxxxxxxx> wrote: > I was really hoping that it would be more efficient to not have to do > all the foreign keys and joins for tables that may have 4-5 enum > types. > > Just being able to: > > SELECT * > FROM tablename > > would be nice if my columns contained enums instead of doing: > > SELECT * > FROM tablename, lookuptable > WHERE tablename.some_id = lookuptable.some_id > > Isn't the join more expensive? You were using natural keys, the join would not be required. Joshua D. Drake > > -- Dante > -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
