Is there an enumeration datatype in postgresql like the enum in mysql? Cheers, Marc ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html