On May 12, 6:51 pm, Jeremy Evans <[email protected]> wrote: > > However, if you plan on updating existing records, my previous message > has a lot of useful information. :) > > Thanks, > Jeremy
Your messages ALWAYS have a lot of useful information. Which is why I lurk here. This infinity issue only arose because some PG list members suggested it to me as an alternative for a fixed date solution. AR migrations handled it without complaint from the get-go so I naively did not give the matter a second thought until I ran into the INSERT problem. PG seems to accept 'Infinity', '+Infinity' and '-Infinity' as string literals (I probably have the capitalization wrong) and returns them the same way. Ruby however, uses 1.0/0 and -1.0/0 to represent Infinity. ruby-1.8.7-p334 :004 > x = 1.0/0 => Infinity ruby-1.8.7-p334 :005 > x => Infinity ruby-1.8.7-p334 :006 > y = 1.0 => 1.0 ruby-1.8.7-p334 :007 > z = x * y => Infinity ruby-1.8.7-p334 :008 > y / z => 0.0 ruby-1.8.7-p334 :009 > It seems a matter of syntax rather than semantics. The AR folks have incorporated a patch to handle this in their PG adapter, which change is scheduled for the 3.0.8 release. Evidently it is left to me to deal with the underlying issue. which is arbitrarily adding all columns with defaults to every insert. Thank you for your helpful and illuminating answer. -- 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.
