temporal version of generate_series()

From: H(dot)Harada <umi(dot)tanuki(at)gmail(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: temporal version of generate_series()
Date: 2008-04-23 10:45:32
Message-ID: e08cc0400804230345t6183074an5c18d613e9e3076b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

I found a TODO item "Add temporal versions of generate_series()" and
wrote patch for generate_series(timestamp, timestamp, interval).

I just copied it from int4.c to timestamp.c and fit the data types in
timestamp and interval. I wonder if we need ones for timestamptz and
time?? If so, the implementation will be so similar that some kind of
generic approach should make things smart. For example, find add '+'
operator function from syscache and take anyelement as arguments.

# This is my first time to send a patch. If I did something wrong, I
appreciate your pointing me out.

Hitoshi Harada

Attachment Content-Type Size
generate_series_timestamp.20080423.patch.gz application/x-gzip 1.7 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Alvaro Herrera 2008-04-23 12:21:06 Re: Snapshot management, final
Previous Message Magnus Hagander 2008-04-23 08:43:23 Re: Improve shutdown during online backup, take 4