Re: How to modify ENUM datatypes?

On Tue, 22 Apr 2008 15:45:39 -0500
"D. Dante Lorenso"  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