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
> >
> >
>
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 |