Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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: generate_series_timestamp.20080423.patch.gz
Description: application/x-gzip (1.7 KB)


pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group