yeah, that's a little too obvious... it has a built-in assumption that doesn't apply to my data: that I do/ can have exhaustive a priori knowledge of the set of values.
I don't, and I can't--partly because the data itself simply isn't knowable in advance, and partly because there are a wide variety of crazy variations. So i'd have to be inserting in the middle of the list all to often, when new "month-names" show up. The problem is about names of issues of magazines: While you can have Jan,Feb,Mar as the standard ordering, you can also have Jan/Feb, Mar/ April, May/June as bimonthly issues, as well as Dec/Jan, Feb/Mar...and quarterly issues like Spring, Summer, Jan/Feb/Mar, plus variations, and then weird combined issues like Spring/Summer, etc. So the numbers I'd have to use would need to be separated like 100, 200, 300 to begin with, so that I could place things in the middle at 150, 250, and then maybe 125, 275... I'm pretty sure the complete set isn't more than 50-60 values, but I'm not absolutely sure. And new variations could appear at any time. So I kinda need to make an arbitrary list where I only have to maintain the sequence, not numbers. On Sep 27, 1:40 am, Rami Ojares <[email protected]> wrote: > One way would be to use integers to represent the months > 1 = Jan, 2 = Feb ... > > - Rami > > On 27.9.2010 3:06, Clint Hyde wrote: > > > I have a table that is about months...names to be precise...which of > > course have > > > ascii_name_order != date_time_order > > > that said, all my incoming info is about the month name. > > > so I'd like to create a custom sort/collation order for this one > > column in this one table. > > > How do I do that? > > > -- clint > > > ------ > > > my db is close to going live for public consumption...I have ~ 1 > > million records in it, text indexing is working properly (yay! thanks!) -- You received this message because you are subscribed to the Google Groups "H2 Database" 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/h2-database?hl=en.
