Обсуждение: temporal algebra and data type
Hello,<br /><br />I am new here, <br />it is a question about "how to colaborate" and/or "where to find", in the scope oftemporal database...<br /><br />-----<br /><br />I see the Temporal Postgres, <br />"a project for making tools and documentationthat people can use to better manage, query, and maintain time data in Postgres", <br /><a href="http://temporal.projects.postgresql.org/">http://temporal.projects.postgresql.org/</a><br/><br />BUT <br />* <spanclass="short_text" id="result_box" lang="en"><span class="hps">the project</span> <span class="hps">is oversized</span><span class="hps">for my needs</span> <span class="hps">...<br /> * there are NO complementar "pure SQL"library for manage "sheduling events".<br /><br /></span></span>Searching I find something more close to my necessities,the S.Bailey's TIMESPAN model, at<br /> <a href="http://scottrbailey.wordpress.com/2009/05/19/timespan-postgresql/">http://scottrbailey.wordpress.com/2009/05/19/timespan-postgresql/</a><br /><br/>BUT it is not ready for practical use (it is more for didactic use)... THEN I create <br /> <a href="http://code.google.com/p/temporal-type">http://code.google.com/p/temporal-type</a><br/>that is what I need.<br /><br/><b>QUESTIONS: </b><br /><br />1) There are another project, similar or better than my!? There are "pure SQL standardlibraries" for this?<br /><br />2) Why something similar (manage events without pg-extension) is not into the <ahref="http://temporal.projects.postgresql.org">temporal.projects.postgresql.org</a> ?<br /><br />3) There are another "goodplace" for colaborate with a simple and "pure SQL" library project?<br /> Can I colaborate to the wiki-page? see<br/> <a href="http://wiki.postgresql.org/wiki/Temporal_Extensions">http://wiki.postgresql.org/wiki/Temporal_Extensions</a><br /><br/><br />
On 22-02-2012 09:50, Peter Padua Krauss wrote: > 1) There are another project, similar or better than my!? There are "pure SQL > standard libraries" for this? > Range Types [1]. It is 9.2 material but it is already in the repository. [1] http://www.postgresql.org/docs/devel/static/rangetypes.html -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte24x7 e Treinamento