Re: A little assistance needed

2005-06-14 Thread Simon Perreault
On Tuesday 14 June 2005 07:27, Rui Fernandes wrote: > But I've got a problem: as usually, my host does > not want to install the modules in the server - so I can't access them this > way. What simple transformations could I do to have a perl script to call > the routine: You can install the module

Re: [OT] Re: Storing recurrences in a SQL DBMS?

2005-05-06 Thread Simon Perreault
On Friday 06 May 2005 12:19, Dave Rolsky wrote: > On Fri, 6 May 2005, Simon Perreault wrote: > > I don't agree with that. What's wrong with the correctness of data using > > XML? XML is a way to enforce correctness in data. Sure, a DBMS also > > enforce correctness

Re: Storing recurrences in a SQL DBMS?

2005-05-06 Thread Simon Perreault
On Friday 06 May 2005 11:13, Dave Rolsky wrote: > The purpose of putting something in a DBMS > is to ensure _correctness_ of the data, and to make it easier to query > that data in a variety of ways, particularly in ways you did not > anticipate when you first created the logical model. Speed may

Re: Storing recurrences in a SQL DBMS?

2005-05-06 Thread Simon Perreault
t > bounded set. That's partly what I did in Chronos (chronoss.sf.net). However, I was dumb at that time and for me "ridiculously far future" was 5 years. *doh!* ;) -- Simon Perreault <[EMAIL PROTECTED]> -- http://nomis80.org

Re: Storing recurrences in a SQL DBMS?

2005-05-05 Thread Simon Perreault
On Thursday 05 May 2005 15:46, Flavio S. Glock wrote: > CREATE VIEW MY_RECURRENCE_28403 ( N ) AS > SELECT ( N + INTERVAL '7 MONTH' ) FROM DT_YEAR; > CREATE VIEW MY_RECURRENCE_83554 ( N ) AS > SELECT ( N + INTERVAL '5 DAY' ) FROM MY_RECURRENCE_28403; > CREATE VIEW MY_RECURRENCE ( N ) AS >

Re: Storing recurrences in a SQL DBMS?

2005-05-05 Thread Simon Perreault
On Thursday 05 May 2005 13:31, Flavio S. Glock wrote: > Flavio S. Glock wrote: > > I'm working on a module that translates datetime sets into SQL > > statements. Can you explain how you can serialize infinite sets? Is it possible to do a query such as "which sets intersect with today?" on the SQL

[PATCH] DT::Locale doesn't handle RFC 3066 language tags

2005-05-05 Thread Simon Perreault
Hi, First, let me congratulate everyone for such a nice toolkit. This is much better than what I've been using previously. I was a bit surprised though when I noticed that DateTime::Locale::load() doesn't accept standard RFC 3066 language tags. This is it expects underscores while the RFC uses