Re: temporal version of generate_series()

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "H(dot) Harada" <umi(dot)tanuki(at)gmail(dot)com>
Cc: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject: Re: temporal version of generate_series()
Date: 2008-05-01 05:02:39
Message-ID: 162867790804302202m210c2fb0qf8981372d9fd280e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Hello

why you don't use polymorphic types?

like:

create or replace function generate_time_series(anyelement,
anyelement, interval, OUT result anyelement)
returns setof anyelement as $$
begin
result := $1;
while (result <= $2) loop
return next;
result := result + $3;
end loop;
return;
end;
$$ language plpgsql;

Regards
Pavel Stehule

2008/5/1 H. Harada <umi(dot)tanuki(at)gmail(dot)com>:
> Here's the sync and updated patch.
> It contains "strict" in catalog as well.
>
> Hitoshi Harada
>
> 2008/4/24 H. Harada <umi(dot)tanuki(at)gmail(dot)com>:
>> 2008/4/23 Alvaro Herrera <alvherre(at)commandprompt(dot)com>:
>>
>> > H.Harada escribió:
>> >
>> >
>> > > # This is my first time to send a patch. If I did something wrong, I
>> > > appreciate your pointing me out.
>> >
>> > Brace positioning is off w.r.t. our conventions -- please fix that and
>> > resubmit.
>>
>> Here's updated version. Thanks for your advice.
>>
>> Hitoshi Harada
>>
>> 2008/4/23 Alvaro Herrera <alvherre(at)commandprompt(dot)com>:
>>
>>
>> > H.Harada escribió:
>> >
>> >
>> > > # This is my first time to send a patch. If I did something wrong, I
>> > > appreciate your pointing me out.
>> >
>> > Brace positioning is off w.r.t. our conventions -- please fix that and
>> > resubmit.
>> >
>> > I have added this patch to the May commitfest.
>> >
>> > --
>> > Alvaro Herrera http://www.CommandPrompt.com/
>> > The PostgreSQL Company - Command Prompt, Inc.
>> >
>>
>
>
> --
> Sent via pgsql-patches mailing list (pgsql-patches(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-patches
>
>

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Greg Smith 2008-05-01 06:32:05 Re: [0/4] Proposal of SE-PostgreSQL patches
Previous Message Greg Smith 2008-05-01 03:24:26 Re: [0/4] Proposal of SE-PostgreSQL patches