Re: How to modify ENUM datatypes?

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