Didn't this work? http://forum.castleproject.org/viewtopic.php?p=15401#15401
On Sep 17, 3:21 pm, Mike Christensen <[email protected]> wrote: > In ActiveRecord, I can easily map a column to an enum.. > > enum enumColors {Green, Blue, Red}; > > [Property(NotNull = true)] > public enumColors Color > { > get { return color; } > set { color = value; } > > } > > In the DB, it creates an integer column type and green is stored as 0, > blue is stored as 1 and red is stored as 2. This is fine. However, I > want to take advantage of Postgres ENUM types: > > CREATE TYPE colors AS ENUM ('Green', 'Blue', 'Red); > ALTER TABLE Foo ADD COLUMN Color colors; > > Now I have a DB type called colors and a column in the table Foo > called Color which is of type colors. The question is how do I map my > class to this data type? ActiveRecord appears to want to read/write > the data as an integer, and Postgres returns it as a string. Any > ideas? Thanks! > > Mike --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Castle Project Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en -~----------~----~----~----~------~----~------~--~---
