Awesome! Thanks for the response. GregD
On Sep 22, 7:57 pm, Jeremy Evans <[email protected]> wrote: > On Sep 22, 1:01 pm, GregD <[email protected]> wrote: > > > Well, after doing a little research. Apparently, Sybase, Informix and > > Ingres support user defined data types (domains in sybase). So, I > > will then assume that no ruby ORM will support them and > > understandable. I guess I could still use migrations, but if I want > > to create or use user defined types (domains), I'll have to use the > > Sybase SQL syntax to do it defeating the purpose for an ORM. Maybe I > > could check the DB type in the migration code and for Sybase use SQL > > syntax and ruby for all others. Still, defeats the many reason for an > > ORM. I just love this app I'm working on and the use of Sybase. <- > > Sarcasm > > PostgreSQL supports user defined types as well. > > Anyway, in terms of migrations, you can just use the domain/type name > directly when creating columns: > > create_table(:blah) do > money :dollars > height :h > locationId :l > id :i > zoneId :z > end > > Creating your domains during migrations is probably going to require > custom SQL, but you can probably create a function that does that and > call it for each domain you want to create. > > Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" 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/sequel-talk?hl=en.
