Re: temporal version of generate_series()

From: H(dot)Harada <umi(dot)tanuki(at)gmail(dot)com>
To: "Pavel Stehule" <pavel(dot)stehule(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 07:36:15
Message-ID: e08cc0400805010036j3101d4c8re559a77027665928@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

2008/5/1 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>:
> Hello
>
> why you don't use polymorphic types?
Ah, good idea. I didn't think we could fix the third argument to
"interval" but "anyelement".
For a temporal version, it's reasonable.

Also, the name "generate_time_series" is better than before?

Hitoshi Harada

2008/5/1 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>:
> 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 Gregory Stark 2008-05-01 10:52:20 Re: [0/4] Proposal of SE-PostgreSQL patches
Previous Message Greg Smith 2008-05-01 06:32:05 Re: [0/4] Proposal of SE-PostgreSQL patches