On Mon, 8 Mar 2004, javier garcia - CEBAS wrote:

> Hi;
> Is it possible to directly create postgres tables with a timestamp column 
> with some specific interval and within a specific range.
> For example every 5 minutes and between the beginning of 1999 and the end of 
> 2003?
> 
> I just need this column.

Sounds like you might want to rethink your data structure.  I would 
suggest using a table with these dates in it as a kind of cross tab table.  
Or look in the /contrib/tablefunc directory for a crosstab function that 
may make what you're trying to do easy.


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to